SAC SMA Function not generating any value

[#1]

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 )

[N1kh1l]

@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