Aggr calculation

[tmumaw]

I'm having a small issue when trying to do a Aggr sum.  Here is my formula and example.  Does anyone see why it would only populate the Midwest East and not New England & SE?  Here is my formula:  aggr(Sum({<Level2=,Level3=,Level4=,[PC Desc]=,[GL Hier 1] = {[ZMR Chart of Accounts]}, YTDFlag = {1},[HighNode] = {'ZMR_GROSS2'}>} [In company code currency_HSL] * -1),FISYR)

[marcus_sommer]

Try it in this way:

sum(aggr(Sum({<Level2=,Level3=,Level4=,[PC Desc]=,[GL Hier 1] = {[ZMR Chart of Accounts]}, YTDFlag = {1},[HighNode] = {'ZMR_GROSS2'}>} [In company code currency_HSL] * -1),FISYR, GM))

- Marcus

[tmumaw]

Nope.  My Gross Sales = Service Line with that calculation.  The top numbers are correct, just can't figure out why they won't duplication for New England & SE

[sunny_talwar · Accepted solution]

Try this

Aggr(NODISTINCT Sum({<Level2=,Level3=,Level4=,[PC Desc]=,[GL Hier 1] = {[ZMR Chart of Accounts]}, YTDFlag = {1},[HighNode] = {'ZMR_GROSS2'}>} [In company code currency_HSL] * -1), FISYR)

[tmumaw]

Thanks Sunny.  It took care of my issue.