hide negative results from calculations

  • Thread starter Thread starter Tine
  • Start date Start date
T

Tine

Hi,

Is there any way I can make negative results (-1) in a calculated field
default to 0 (zero)?
I only want to show positive results. All calculations are based on 1000

Example
---------
Show: 1000 + 104 (results would be 104)
Do not show: 75 + 179 (results would be -821)


Help is much appreciated.
 
And for a third response...!

In a query, you'd use the IIF() function, something like:

IIF([YourAnswer]<0,0,[YourAnswer])
 
Back
Top