Expression not working properly

[#1]

Dear All,

Expression not working properly.

i've attached app. pls check and let me understand the issue.

Thanks

ASHIF

[mjm]

Hello Ashif,

Please can you be more specific on what you need. Which expression are you having problems with?

[maxgro]

Duplicated record?

[miguelbraga]

Hi Ashif,

Maybe your wrong calculation should be something like this?

=count(DISTINCT AMOUNT)

Please check if that is your correct output

Regards,

MB

[sunny_talwar · Accepted solution]

May be use this expression:

Sum(Aggr(Avg(Qty), AMOUNT, KEY6))