How can I create a decimal field that multiplies every user entry by (-1)

AntonyNgorora7

Good day. I wanted to ask, how I can implement a negative field calculator. For example, if a user enters the value 6, the field auto calculates this entry to -6, and if the user types -3, the field auto calculates the result to 3.

Cyberghost

in the validate trigger, just put the following:

Dec := -Dec;

with Dec being your field. Should change the sign. Multiplying the decimal by -1 would also work.

Cyberghost

in the validate trigger, just put the following:

Dec := -Dec;

with Dec being your field. Should change the sign. Multiplying the decimal by -1 would also work.

AntonyNgorora7

Thank you, let me try it out.

AntonyNgorora7

Thank you so much, it worked perfectly!