yesterday
We are able to create a Simple Moving Average (SMA) calculation in our SAP Analytics Cloud model without any errors. However, the calculation does not return any values.
The calculated measure is created successfully and no validation or runtime errors are displayed, but the result is always blank when used in the model or in a Story.
Defination : SMA([Active_Emp] ,[d/Date],"Month" ,3 )
Request clarification before answering.
Could you show the original measure [Active_Emp] values by month. SMA will show you moving average of the last 3 periods and date has to be in your table in row or column axis with drill set to months.
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 6 | |
| 6 | |
| 5 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.