Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You need to either do what Pierre de Calan mentioned or check "Suppress Zero Values" on the Presentation tab.
I have checked ‘Suppress Zero Values’ already – it doesn’t work