Excluding data using Set Analysis

[anthony_kinsell]

Hi,

I'm trying to do a graph of Budget vs Actual but don't want 'Contract Sales' included in my Budget figures.

I know the below formula gives me just Contract Sales but how do I exclude them:

Sum ({<FundHeading = {'Contract Sales'}>} DevBudgetAmount)

Tried various attempts of 1 - contract sales but can't seem to get it to work?

[Nicole-Smith]

You need to either do what Pierre de Calan mentioned or check "Suppress Zero Values" on the Presentation tab.

[anthony_kinsell]

I have checked ‘Suppress Zero Values’ already – it doesn’t work