IF NOT formula

[#1]

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!

[#2]

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

[SunilChauhan · Accepted solution]

if((PACKAGE_CONFIG <> 'No Package'),sum(TOTAL_ALLOCATION))

its always better to write sum in starting

sum(if(PACKAGE_CONFIG <> 'No Package',TOTAL_ALLOCATION))