Wrong AVG in Chart

[francisvandergr]

I have no good result for an avg when i count with 2 columns

I included an example.

Can someone help

[swuehl]

Try this as expression for Avg:

=[Total Amount]

/

Rangesum(Above(count(if(Project_Aanneemsom > '0' or Project_Aanneemsom < '0' or Meerwerk_Bedrag > '0' or Meerwerk_Bedrag < '0' ,Project_Code)),0,Rowno()))

[sunny_talwar · Accepted solution]

Check the attached

Change the expression for Qty from full accumulation to no accumulation and used the RangeSum(Above()) expression

RangeSum(Above(count(if(Project_Aanneemsom > '0' or Project_Aanneemsom < '0' or Meerwerk_Bedrag > '0' or Meerwerk_Bedrag < '0' ,Project_Code)), 0, RowNo()))

[swuehl]

If you want to keep your totals, maybe use a Qty expression like

=FirstsortedValue(

Aggr(

  Rangesum( Above( count(if(Project_Aanneemsom > '0' or Project_Aanneemsom < '0' or Meerwerk_Bedrag > '0' or Meerwerk_Bedrag < '0' ,Project_Code)),0,rowno() ))

  ,Week)

, aggr(-Week,Week)

)

or if your Qty line values can't be negative, maybe just

=Max(

Aggr(

  Rangesum( Above( count(if(Project_Aanneemsom > '0' or Project_Aanneemsom < '0' or Meerwerk_Bedrag > '0' or Meerwerk_Bedrag < '0' ,Project_Code)),0,rowno() ))

  ,Week)

)