Skip to Content
Aug 01, 2019 at 05:11 AM

Unable to apply aggregation on particular Node in Hierarchy object in Webi


Hi Mentors,

I am using Webi 4.2 Support Pack 5 Patch 4 ver

I am unable to apply Sum() on a Particular node "Gross Sales" in a Hierarchy object . I have tried with this expression . I have tried other Set Functions also like Children, Descendants etc. and every time it has given the error which i mentioned below . the path is not correct.

=Sum([Amount in CC Crcy];{[Profit & Loss].[Gross Profit].[Net Sales Value].[Gross Sales]})

But the expression is giving the below error:

Please help me with the right expression.

Thanks in Advance.


oybxe.png (9.0 kB)
fhbho.png (10.3 kB)
c4abn.png (4.3 kB)
1anso.png (34.8 kB)