Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to create a pie chart that sums all of a certain amount, exlcuding records for which "Package Config" = "No Package". The "Package Config" dimension is not used in the pie chart, just Supplier. The weird thing is: if I apply the formula below to a bar graph that has "Package Config" as one of the dimensions, it works perfectly.
Here is my attempt (not working for pie charts):
=if(not(PACKAGE_CONFIG = 'No Package'),sum(TOTAL_ALLOCATION))
What am I doing wrong? Can the IF NOT function only be used if the chart includes the dimension that I'm trying to qualify?
Also: I would love to do this using Set Analysis, but don't know how.
Thanks!
if((PACKAGE_CONFIG <> 'No Package'),sum(TOTAL_ALLOCATION))
its always better to write sum in starting
sum(if(PACKAGE_CONFIG <> 'No Package',TOTAL_ALLOCATION))
Hi...
can you give this a try?^^
Dimension tab:
Supplier (check "Suppress When Value is Null")
Expression tab:
sum({$<PACKAGE_CONFIG -={'No Package'}>} TOTAL_ALLOCATION)
Best Regards,
Alex
if((PACKAGE_CONFIG <> 'No Package'),sum(TOTAL_ALLOCATION))
its always better to write sum in starting
sum(if(PACKAGE_CONFIG <> 'No Package',TOTAL_ALLOCATION))