Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I need to convert if condition into setanalysis as below.
if( Child_3 = 'Package'
sum(BDA) + Sum(GBA),sum(Outstand))
- Priya
May be this:
Sum({<Child_3 = {'Package'}>}BDA) + Sum({<Child_3 = {'Package'}>}GBA) + Sum({<Child_3 -= {'Package'}>}Outstand)
or
RangeSum(Sum({<Child_3 = {'Package'}>}BDA), Sum({<Child_3 = {'Package'}>}GBA), Sum({<Child_3 -= {'Package'}>}Outstand))
May be this:
Sum({<Child_3 = {'Package'}>}BDA) + Sum({<Child_3 = {'Package'}>}GBA) + Sum({<Child_3 -= {'Package'}>}Outstand)
or
RangeSum(Sum({<Child_3 = {'Package'}>}BDA), Sum({<Child_3 = {'Package'}>}GBA), Sum({<Child_3 -= {'Package'}>}Outstand))
I have pivot table child_3 is a dimension, for child3 there are multiple values like below
Child_3 Expr(for all other than 'Package', expr is sum(outstanding) for package expr is sum(BDA) + sum(GBA)
xxy
yyz
'Package'
Right, did the above expression not work? Can you provide a sample?
above expr didn't work
Would you be able to share a sample?
Data:
Seems to be working just like the if statement:
Thanks Sunny... it is working
Awesome
I wasn't sure what I might have been missing, but I am glad we were able to resolve it quick enough.
Best,
Sunny