Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
For below TermDen field, I want it to be 12 for all three rows in TERM=1, and 18 for three rows of TERM 2. I must aggregated wrong, please advise, the app attached.
Try this
Sum(TOTAL <TERM>DEN)
or this
Aggr(NODISTINCT Sum(DEN), TERM)