Wrong Avg in linechart

[francisvandergr]

Hi i have a linechart what counts with the wrong quantity. It counts with sum of rows,  instead of expression total.

I included an example over all weeks, i wanna count with 190 instead of 210

[sunny_talwar]

Which object are we talking about here?

[Kushal_Chawda]

Use Aggr function to aggregate the value for particular dimension

[francisvandergr]

linechart avg sales is wrong. Total rows of chart Details has 190 rows

[francisvandergr]

I used this formula:

=rangesum(above(sum( {$<Project_Projectleider = {'*'}-{'Bert Schilt'}>} Meerwerk_Bedrag ) , 0 ,RowNo() ) +
rangesum(above(sum( {$<Project_Projectleider = {'*'}-{'Bert Schilt'}>}Project_Aanneemsom ) , 0 ,RowNo() ))) 
/
  Aggr(
Rangesum( Above( count(distinct(if(Project_Aanneemsom > '0' or Project_Aanneemsom < '0' or Meerwerk_Bedrag > '0' or Meerwerk_Bedrag < '0' ,Project_Code))),0,rowno() ))
,Week)

[sunny_talwar]

What are the expected number on the chart?