Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have account numbers like
AC NO AMOUNT
1 50
1 50
2 100
2 100
3 100
I would like to have a sum on distinct account numbers, for ex: in above scenario i would like to have a total as 250, sum of amount for the
distinct accounts. Please help me.
Thanks,
Abhi
Maybe
=sum( aggr( only(AMOUNT), [AC NO]))
Try below
=SUM(AGGR(DISTINCT AMOUNT, [AC NO]))
Check out the attached file hope it helps.
Thanks
AJ