Export to excel - Decimal and integer in the same column

[malin_ortengren]

Hi,

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

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?

[advait_thakur]

Hello Malin,

  could you please post your sample application file..!!

Thanks

Advait

[malin_ortengren]

Hi,

Here is an example with my problem.