We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

% of Column Calculated Value is getting divided by 100 on Export to Excel

Answered
Amogh Arsekar asked on October 23, 2024

When I add a calculated value I am setting the formula as percent('derived')/100 and giving it the correct format object with decimal values as 2 and isPercent as true. The values appear properly in the Pivot grid but when I export to excel the values get divided by 100 again. ie: 100.00% appears as 1.00%

3 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster October 24, 2024

Hello Amogh,

Thank you for contacting us.

We could not reproduce the described behavior on our side. Please check the following JSFiddle: https://jsfiddle.net/flexmonster/sfqon8aL/. When exporting to Excel, the percent values seem to be displayed correctly. If the issue still occurs, please feel free to modify the example.

Looking forward to hearing from you.

Kind regards,
Nadia

Public
Amogh Arsekar October 28, 2024

Hello Nadia,

This behavior was fixed after upgrading to the latest version of Flexmonster. I was on the 2021 version earlier.

Thanks

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster October 28, 2024

Hello Amogh,

Thank you for the feedback!

We are glad that upgrading to the latest version resolved the issue.

You are welcome to contact us if other questions arise.

Kind regards,
Nadia

Please login or Register to Submit Answer