How to show the amount as a negative in a text field

[Nandini Mishra]

Hi All,

I have a requirement to show the Total amount field from the request table to be shown on billing table as a negative

for eg, Total amount on Request table is 230$ in a text field, then it should be reflecting in Billing table on a text field as "-230$"

How to show this?

[Sree Sudhan]

Hi @Nandini Mishra 

If your requirement should always display the negative value on a particular text field. Then try creating a Before insert Business rule on your Billing table.

Hope this helps

Regards,
Sudhan