Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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)
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
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
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)
Thanks Sunny. It took care of my issue.