Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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))