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,
I try to get each rolling 4 Quarter Average incase particular quarter no data found in Table then it should consider as Zero for the specific quarter and calculate average and tried the multiple way of formuls as doesn't works. shared the file in Google drive in sample file and i don't know how to share other way around. Thanks!