how to set field with negative value to show nothing?

[mmonsalveg]

Hello ,

i would like to know if i can set a field to show 0 or nothing if the value is a negative number?

please let me know

thank you

Mauricio

[Lee Smith]

Use the Auto Enter on the field

Case ( Self > 0 ; Self; 0)

and deselect the "Replace existing value"

[Lee Smith]

BTW, to make it blank result, you can just change the second 0 to "" as I did in the script version.

Go to Record/Request/Page

[ First ]

Loop

Set Field [ yourField; Case ( yourField > 0 ; yourField; "" ) ]

Go to Record/Request/Page

[ Next; Exit after last ]

End Loop

[mr_vodka]

Are you really on FM9?

If not, then you can use a conditional format on the field.

value is less than 0

Make the font size 500 point in the formatting.

[Lee Smith]

Are you really on FM9?

Good question John.

[Raybaudi]

Are you really on FM9?

If not, then you can use a conditional format on the field.

FM9 had the conditional format option.