Hi There,
I am relatively new to Jet Reports and I am sure the answer is quite simple but I can't seem to get it. I am pulling data using the following command
=NL("LinkSum","Detailed Vendor Ledg. Entry","Amount")
The values all come out as negatives as that is the way the data is stored in the tables, how can I reverse the sign?
I tried the following
=-NL("LinkSum","Detailed Vendor Ledg. Entry","Amount") and I get a #VALUE error
Any help would be greatly appreciated.
Date
Votes
1 comment
-
Jet Reports Historic Posts hi g2systemsgroup,
just put an (*-1) behind your code
=NL("LinkSum","Detailed Vendor Ledg. Entry","Amount") * (-1)
regards
jetsetter
Please sign in to leave a comment.