Total as Negative amount

  • Last Post 2 weeks ago
sara posted this 22 July 2019


On an invoice Total value is " ($45.18). It is detected as "45.18" in the field box. How to get the total value is displayed as "-45.18" ?

Thanks and advance.

Order By: Standard | Newest | Votes
Ekaterina posted this 5 weeks ago


The Amount of money type of data used in Total field cannot be negative.

sara posted this 2 weeks ago

Hi Ekaterina,

45.18 value is on bracket and i want to display it as -45.18 as its a negative value. So what changes i need to do? 

Also sometimes there is a space between the values such as 45 18. How to make it as 45.18?

sara posted this 2 weeks ago

Hi Eric,

As i told in beginning , Value of Total amount is (45.18) , values are in brackets. How your script will remove bracket and display as negative value? Also there are positive values also. By your script those will become negative. Data type is "Amount".