jpadilla
10th April 2003, 16:54
How can I change the negative amount format e.g.
actual - 15000
to (1500)
in all reports ???
Hitesh Shah
10th April 2003, 18:37
U may use the print format in report layout fields (ttadv3134s000) surrounded by bracket removing the leading / trailing minus signs e.g (ZZ9VD99) instead of ZZ9VD99-
Further if the print format is written using % sign (meaning defined in data dictionary like %A095 , %Q004 etc) , u need to change number formats for the currencies for which reports are printed (mainly home currency) in session ttaad1107m000 .
Also note the language/currency (expression) also affect the print format in such cases.
When the print formats are changed , u need to re-compile the report.
There is no standard way of modifying the print format for all reports in the system to the best of my knowledge.
If u need to change value of the report field besides formatting , u can merely use print expression for this e.g amth/10 for print 15000 as 1500
Heartless
15th August 2014, 09:59
what if -1500?
I want to print out 1500 in report without bracket.
bhushanchanda
15th August 2014, 18:04
Hi,
Use abs(amount). It will convert negative amounts to positive.