I have this calculation and it works.
Aggr(NODISTINCT Sum({<Resi={RESI},[GL Hier 1] = {[ZMR Chart of Accounts]},[HighNode] = {'ZMR_GROSS2'}>} [In company code currency_HSL] * -1), FISYR)
However I have Node1 locked on R130000000, R183000000 and R190000000. I wanted to add this to my calculation and for some reason it does not work. Does anyone see what I might be doing wrong? Thanks.
Aggr(NODISTINCT Sum({<Resi={RESI},[GL Hier 1] = {[ZMR Chart of Accounts]},[HighNode] = {'ZMR_GROSS2'},Node1={R11000000, R130000000,R183000000,R190000000}>} [In company code currency_HSL] * -1), FISYR)
