Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I make this formula

Status
Not open for further replies.

TheDudee

Technical User
Jul 15, 2005
1
NL
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
 
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.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top