dont display minus in number field

[transit]

Hi all

I have a calculation field that has a possibility to return a minus number, but i want it to return only "0" for any minus numbers.

Can anyone please help

many thanks

[SassyTexan]

In calcs like this I have used another parameter in my calculation that says if <0 then 0.

i.e. If(X-Y<"0",0,X-Y)

Hope that helps.

[transit]

thanks sassytexan

That does help perfectly

many thanks

[CobaltSky]

...or you could use:

Max(0, X - Y)