2 Replies Latest reply: Apr 25, 2012 2:26 AM by Sunil Chauhan RSS

    IF NOT formula

      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!