Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have fields like P_Code, flag and Date.
If I am trying to do sum(Flag) against P_Code then it will get wrong result because of each date have P_Code.
But My requirement is to get the sum(flag) against the P_Code. I am trying to use below expression.
Sum(Aggr(Only(Distinct Flag), P_Code))
If I am trying do sum of flag then it will take all P_Code data.
Can you please suggest me how to do sum(flag) against the P_Code and how to eliminate P_Code duplicates.
Thanks & Regards,
Lakshman
Try below.
=Sum(DISTINCT {$<P_Code= {“=Count({1} P_Code) = 1”}>} Flag)