How do I make this formula

[TheDudee]

I've a field called: budget and schema

The budget contains measures and schema contains dimensions.

schema has fixed fields(costs and revenu).

I made a repport which shows costs and revenu in collums and the budget in the rows. See belows

Costs Revenu
Budget 10 20

How can i make a formula which calculates the difference between these two collums.

PLEASE HELP

 

[Madawc]

You should be able to say Costs - Revenu, but make sure it is a signed field.

If some of these fields came out blank, that would indicate you had nulls. You'd need to do isnull tests first.

Madawc Williams (East Anglia, UK)