excel export not working correctly when using expression default

[felcar2013]

dear community

i have some formulas represented as variables in the script. i formatted them using num() and under chart properties / number / number format settings, i use "expression default".

in the script i declared the variables like: set vRedemptionRate = num($(vRedemption)/$(vRecipients),'#.##0,0%');

i have realized that when i export a table to excel, it exports the percentage numbers as decimal with many numbers after the "comma" or decimal point

but if i set under Number Format Settings, "fixed to" (for decimals) and " show in percent", then the export to excel is correct.

Why using the variables and the "expression default" it does not work correctly?

thanks for the help

felipe

[vadimtsushko · Accepted solution]

Hi, Felipe.

I've recently found that while Num() function does not work with 'Send to Excel', Money() function actually does work.

So in your sample Money($(vRedemption)/$(vRecipients),'#.##0,0%') should work (looks funny I know)

Tested on QV11 SR4 and SR5

Best regards, Vadim Tsushko

[felcar2013]

Thanks Vadim, is good to know