Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to display the average only for the months with a proven track record.
In the formula below, the average is displayed including the months without values.
Rangeavg(above(Sum({$<KPI={'TEST'},[KPI_Year]={$(tmpYear)},[KPI_Month]=>}Act),0,rowno()))
Add Act={"<>0"} to your set-analysis
Thank you for your reply.
I tried what you taught me, but the result did not change.
It works at table chart.
regards,
Looking further into it, I think that rangeavg(above()) statement will always sum up each row.
If this is the case the only solution would be using if statement.
If( Len(trim(Acc))=0 or Acc =0, 0, rangeavg(above(...)) )
But i'n not convinced about the correctness of my thoughts. I think it would nevertheless take the zero values into account when calculating a second vlaue that have severela zero values between.
Thank you for replying again.
I think it is difficult to use if statement.
I'll think of a different solution.
regards,