Forum Discussion
4Q Rolling Average (Cumulative Average) Include 0 value
Dear Team - I am trying to calculate each four Quarter Rolling Average which include 0 value as my formulas does not works well. Its excluding zero value and calculate measure. But i need to inc...
Hi Anonymous ,
Your measure works fine on my end. Are those zeroes actually zeroes or they're blank because your fact table doesn't have data in those quarters/those quarters do not exist in your fact table?
absolutlely you're right.. My fact table doesn't have value on specific date then my 4 Quarter average doesn't calculate as expected.
Example measurement takes where we don't have value in Fact Table then it takes SUM of Total / 4 as average (wrong answer) = 34,637
How can we fix this. pls suggest