Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I created an input box linked to a variable vMyVar with as constrain Num#(vMyVar,'#.##0,00', ',' , '.')
My default format looks like:
SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00;(#.##0,00)';
I created an input box linked to vMyVar.
In a chart/table I have an expression:
((sum([Hours1])+sum([Hours2]))*$(vMyVar))/sum([total_books])
The Hours1 and Hours2 are displayed like 1.000,50
In QVD they look like 1000.50
When I enter 1.5 in the input box then the calculation is correct.
When I add 1,5 in the input box then I don't get any result.
Does anybody know why?
Thx
Or use Replace function to allow entering both 1.5 and 1,5.
Try $(=num#(vMyVar,'#.###,00',',','.')) in your expression instead of $(vMyVar)
Or use Replace function to allow entering both 1.5 and 1,5.
Thx, this iw working perfect
Thx, is working perfect