4 Replies Latest reply: Jun 12, 2013 9:09 AM by Mario Van De Walle RSS

    Input Box Currency Format

    Mario Van De Walle

      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