Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day All
Trust you are well!
I am looking to convert the amount and units received from a JD Edwards tables.
Line 1: The amount should be in the format R3 920.00 but instead it spits out 392000 and when i change he number format to Money it gives me R392 000.00 which is incorrect.
Also the units should be 16 but it gives me 16000.
Check the values of these system variables in the script of your document.
SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
Perhaps in your document you need to change the values of these variables.
Thanks for the help, but still getting the same after changing the variables.
Did you change the variables in the script and reload the data?
Yes i did it in the script.