Vizlib Home
Welcome
Login

WriteBack number formatting error

image


 

I have an issue with number formatting on WriteBack.


Our regional settings for thousands and decimals are (.) and (,) respectively, so "One thousand two hundred and fifty and 56 cents" is represented as "€1.250,56"
In my "Main" section of my QS code I have:
SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='€#.##0,00;-€#.##0,00';


If you look at the screen shot, I have THREE things that appear to be working incorrectly:

a) The blue circles show you the numbers on my P&L that are being edited - they have decimal places yet when displayed on the Writeback table the decimal places disappear (see the 2nd entry 245.267) They are only shown as intergeres

b) When you click on the entry the decimal places appear (as you can see in the first entry 697.373,69

c) The formatting is ignoring the settings in Main and shows them in "UK" format 
d) The column in red is a calculated column that calculates Column(5)-Column(4). This is showing ERROR I suspect because it does not understand the number formatting.
I have spent the ENTIRE day and not making progress - Can someone assist or point me to the right direction. I have attached the screenshot as a file for more detail.
Thanks
Alexis



Login to post a comment