2 Replies Latest reply: Apr 2, 2013 5:00 AM by Malin Örtengren RSS

    Export to excel - Decimal and integer in the same column

    Malin Örtengren

      Hi,

      I have columns in a table that contains both decimal and integer. It is a incomestatement with both ratios and lines.

       

      Exempel tabell.PNG

       

      To format this the function num() is used today:

      if(right(Summeringsrubrik,1)='%',num(((sum({$<Procentuträkning={"T"}>} Belopp)/sum({$<Procentuträkning={"N"}>} Belopp))*100),'# ##0,0')&'%',

      num(sum(Belopp),'# ##0'))

       

      Unfortunately,when exporting to Excel the value is presents as text instead of numbers.

      Does anyone have a good solution to this?