cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

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 )

0 Likes
View Entire Topic
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