Total as Negative amount

  • Last Post 05 December 2019
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 15 November 2019


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

sara posted this 02 December 2019

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 05 December 2019

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".