Expand my Community achievements bar.

I want to set a calculated field to not display a negative number

Avatar

Level 3

I'm trying to set a calculated field to display as 0 if a negative number is calculated. How would I do this?

3 Replies

Avatar

Level 2

Can't you just check it in Javascript?

if (field.rawValue < 0) {

    field.rawValue = 0;

}

Avatar

Level 3

Thanks for the help, but this doesn't work because my calculation is in FormCalc.

Avatar

Level 7

Try:

Max(Field1,0)

Will pick Field1 value, or 0, whichever is greater.