topic Show average only if you have a track record in App Development

Show average only if you have a track record

tatsuya0127 — Mon, 14 Feb 2022 05:52:02 GMT

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()))

Re: Show average only if you have a track record

chris_djih — Mon, 14 Feb 2022 10:41:31 GMT

Add Act={"<>0"} to your set-analysis

Re: Show average only if you have a track record

tatsuya0127 — Tue, 15 Feb 2022 00:37:55 GMT

Thank you for your reply.

I tried what you taught me, but the result did not change.

It works at table chart.

regards,

Re: Show average only if you have a track record

chris_djih — Tue, 15 Feb 2022 07:48:06 GMT

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.

Re: Show average only if you have a track record

tatsuya0127 — Tue, 15 Feb 2022 07:54:28 GMT

Thank you for replying again.

I think it is difficult to use if statement.

I'll think of a different solution.

regards,