Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have no good result for an avg when i count with 2 columns
I included an example.
Can someone help
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()))
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()))
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()))
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)
)