2 Replies Latest reply: Jun 14, 2018 7:13 AM by Peter Hultman RSS

    Money format issues (both app and export)

    Peter Hultman

      I am struggling to get the money format correct in my apps.

      In the script I have the following settings:

       

      SET ThousandSep=' ';

       

      SET DecimalSep=',';

      SET MoneyThousandSep=' ';

      SET MoneyDecimalSep=',';

      SET MoneyFormat='# ##0,00 kr;-# ##0,00 kr';

      SET TimeFormat='hh:mm:ss';

      SET DateFormat='YYYY-MM-DD';

      SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]';

       

      The measure I present is coded like this:

      Money(Sum(count*netprice))


      In a pivot table it looks correct:

      1.PNG

      But when exporting to Excel it looks like this (missing spaces):

      3.PNG


      In a bar chart it looks like this (spaces missing):

      2.PNG


      And when exporting to Excel I get this (spaces still missing):

      4.PNG


      If I change the number format in my bar chart from "auto" to "currency" I get this:

      5.PNG


      And when exporting to Excel I get this (values are correct but presentation is divided by 1000):

      6.PNG


      I would be very grateful if someone could explain to me what is going on and how to get it right


      /Peter

        • Re: Money format issues (both app and export)
          praveen kumar

          Hi Peter,

           

          Check the ThousandSep Once in ur Script , i am seeing Blanks . compare with Default Script down ..

          your Script has Blank Settings in Thousandsep

          and MoneyThousandSep

          and

          MoneyDeccimalSep should be '.';

          in your case it is ',' ;

           

          SET ThousandSep=' ';

           

          SET DecimalSep=',';

          SET MoneyThousandSep=' ';

          SET MoneyDecimalSep=',';

          SET MoneyFormat='# ##0,00 kr;-# ##0,00 kr';

          SET TimeFormat='hh:mm:ss';

          SET DateFormat='YYYY-MM-DD';

          SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]';

           

           

          Normal Default Script :

          SET ThousandSep=',';

          SET DecimalSep='.';

          SET MoneyThousandSep=',';

          SET MoneyDecimalSep='.';

          SET MoneyFormat='$#,##0.00;($#,##0.00)';

          SET TimeFormat='hh:mm:ss';

          SET DateFormat='M/D/YYYY';

          SET TimestampFormat='M/D/YYYY hh:mm:ss[.fff]';

           

           

           

          This might be Helpful to process furthur...

           

          Thanks

          PM