In my Expression, sum( {1 < Flag = {1}> }AMT*FREQ), I want to add one more condition, Where Sales Id is distinct. How to add this condition in my expression...

[#1]

In my Expression, sum( {1 < Flag = {1}> }AMT*FREQ), I want to add one more condition, Where Sales Id is distinct. How to add this condition in my expression...

Thanks in Advance

Siddharth

[jyothish8807]

Hi Sidd,

Try like this:

aggr(distinct sum( {1 < Flag = {1}> } AMT*FREQ),Sales ID)

Regards

KC

[sunny_talwar]

Not sure what you are looking for, but may be this:

Sum({1<Flag = {1}, [Sales Id] = {"=Count([Sales Id]) = 1"}>} AMT*FREQ)