nested sum

[JoseGarcia]

Hi all, 

formula below is coming as incorrect. Unable to perform nested sum:

Sum(Count({<Business={'RS&S'}>}Business) + Count({<Business={'SS&I'}>}Business) + Count({<Business={'Corporate'}>}Business)
+ Count({<Business={'Urban'}>}Business))

where am i going wrong here?

Thanks a million

Jose

[MayilVahanan · Accepted solution]

Hi @JoseGarcia 

Nested aggregation is not possible until u use aggr function.

In your case, are u adding the count values alone. In that case, simply try like below

Count({<Business={'RS&S','SS&I','Corporate','Urban'}>}Business)

or

Count({<Business={'RS&S'}>}Business) + Count({<Business={'SS&I'}>}Business) + Count({<Business={'Corporate'}>}Business)+ Count({<Business={'Urban'}>}Business)

or

u can use rangesum function like

Sum(Count({<Business={'RS&S'}>}Business) ,Count({<Business={'SS&I'}>}Business), Count({<Business={'Corporate'}>}Business), Count({<Business={'Urban'}>}Business))