If you have a negative number and multiply it by -1 it is the positive of that number.
-600 x -1 = 600
600 x -1 = -600
It reverses positive and negative.
Formulas in samba is not my forte but I would hazzard a guess
[=TN(TN('{CALCULATION TOTAL}')*1000*-1)]
Or something along those lines - might need to add some brackets possibly but try that first.
If you ever want to test it… just use a show message and insert the tag you want to test the output of… no formatting just the tag… if it produces something like 1,323 then you need to use TN to convert it to 1323 when used in expression.
Thanks, sorry for my ignorance on the subject.
Just one last thing so I know I understand correctly; string and numerical, which way round is that? String if the formatted value the tag calls for and TN makes it plain numerical value?
Example {TICKET NO} would never need TN because it only produces numeric output… but {TICKET TOTAL} always produces #.## format so you would need TN if used in expression.
You cant wrap it with TN and it print the numeric format… the conversion is internal its so it can evaluate the expression it will still print it formatted. You can change that format with F or FF
@spanky I hope I didnt confuse you with this… in your case TN is needed. I was just pointing out some additional info.
Depends on where he is using {CALCULATION TOTAL} my example was in a printer template outside of formatting… but if hes using it in [SERVICES] or somewhere else then {CALCULATION TOTAL} would work.