Aggregation Help

[ivandrago]

Hi,

I have the attached document, I want the value from the text box "Value Required" but I am getting the wrong value based on the chart. I think the reason for this is because there are multi lines for the same ID due to different RuleID.

Thanks

[srinivasa1]

USe

distinct  as below in  chart experssion

sum( distinct poPrice* (poQty))

It will show exact value.pls check and let me know

[ivandrago]

Hi,

It does not seem to work, I've attached another document with more data and I have added your expression to the chart "wrong value 2" and the results are not matching the "Value Required" as you can see.

Thanks

[#4 · Accepted solution]

Try with this:

Sum(Aggr(sum(DISTINCT poPrice * poQty), ID))

Regards,

Ricardo