Nested Aggregation Not Allowed

[manisharora]

Hi Mates,

I am trying to implement this logic in my expression editor but it's throwing me nested aggregation not allowed error,

If anybody knows,

Kindly help,

(((Sum({< FiscalYear= {'$(vMaxYear)'}, CalendarMonth= {'$(vMaxMonth)'} >}([Net Amount]

-

(Sum({< FiscalYear= {'$(vMaxYear)'}, CalendarMonth= {'$(vMaxMonth)'} >} A)+
Sum({< FiscalYear= {'$(vMaxYear)'}, CalendarMonth= {'$(vMaxMonth)'} >}B)+
Sum({< FiscalYear= {'$(vMaxYear)'}, CalendarMonth= {'$(vMaxMonth)'} >}C)+
Sum({< FiscalYear= {'$(vMaxYear)'}, CalendarMonth= {'$(vMaxMonth)'} >}D)+
Sum({< FiscalYear= {'$(vMaxYear)'}, CalendarMonth= {'$(vMaxMonth)'} >}E)+
Sum({< FiscalYear= {'$(vMaxYear)'}, CalendarMonth= {'$(vMaxMonth)'} >}F)+
Sum({< FiscalYear= {'$(vMaxYear)'}, CalendarMonth= {'$(vMaxMonth)'} >}(G))+
Sum({< FiscalYear= {'$(vMaxYear)'}, CalendarMonth= {'$(vMaxMonth)'} >}H)+
Sum({< FiscalYear= {'$(vMaxYear)'}, CalendarMonth= {'$(vMaxMonth)'} >}I))

))/$(vCr))

Regards

[rwunderlich]

I think you just have your parens in the wrong place. It looks like you want to 

Sum [Net Amount] then substract A+B+C etc.

If I understand correctly, than you need a closing paren after [Net Amount]

-Rob