cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SAC SMA Function not generating any value

Chakri1
Newcomer
0 Likes
35

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 )

Accepted Solutions (0)

Answers (1)

Answers (1)

N1kh1l
Active Contributor
0 Likes

@Chakri1 

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