6 Replies Latest reply: Nov 29, 2016 4:58 PM by Seth Rosenbauer

# Suppress when value is null chart issue

Is it possible to suppress a dimension when the value is null and have an expression that calulates a percentage and the total of that percentage adds up to 100.

See the example below.

PersonSales% of Total Sales
Sam 1010%
John2525%
Mark5050%

--in this example, there are 15 sales that are 'null' and I don't want to include. However, I still want the % to add up to 100 when I suppress null values

• ###### Re: Suppress when value is null chart issue

It seems I don't understand how you calculate your % from the sales values (not even the detail lines).

Could you explain how your calculation works?

Or post a small sample QVW?

• ###### Re: Suppress when value is null chart issue

Or maybe your sales are not NULL, but the dimension Person these sales are linked to?

• ###### Re: Suppress when value is null chart issue

=Sum(Sales) / \$(=Sum(Sales))

• ###### Re: Suppress when value is null chart issue

Check the box Supress when value is Null in the Dimensions tab! Try like this as attached.

Updated!

• ###### Re: Suppress when value is null chart issue

hi

use this expression to calculate the share

sum(Sales)/sum({<Person=p(Person)>}Total Sales)

• ###### Re: Suppress when value is null chart issue

Thanks everyone, I was able to figure it out with all of your help!! Sum(Sales)/\$(=Sum(Sales) worked!!!!