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

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

44 Views

Hi Mentors,

I am using Webi 4.2 Support Pack 5 Patch 4 ver 14.2.5.2813.


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.

Attachments

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