I've written a formula for a dropdown but it's not triggering correctly. Maybe someone will be able to help.

It's a visibleIf. We want manager_approval_c visible if discount_total_c is less than 0. I've written the following formula but the field is visible even if the total discount is 0 or greater than 0. I've used 2 variations of it.

1st try:

not(greaterThan($discount_total_c,0))

2nd try:

not(greaterThan(number($discount_total_c),0))

Is something wrong with my formula? What does greaterThan return if it's negated?

We're running Enterprise 7.5.0.1 On-Premise.

Thanks so much!

It's a visibleIf. We want manager_approval_c visible if discount_total_c is less than 0. I've written the following formula but the field is visible even if the total discount is 0 or greater than 0. I've used 2 variations of it.

1st try:

not(greaterThan($discount_total_c,0))

2nd try:

not(greaterThan(number($discount_total_c),0))

Is something wrong with my formula? What does greaterThan return if it's negated?

We're running Enterprise 7.5.0.1 On-Premise.

Thanks so much!

Try using "abs()" instead of "number()". This will show negative numbers and may make the greaterThan() function behave the way you expect.

Kind Regards,

Jason Smith