SV: FR report decimal number customisation does not save after a REFRESH of the report
Content
Hi all
When we open a Financial Reporting in Excel, and change the data display to a customised number (we do not want to see the decimals in the grid), it works fine after the changes are made under the Excel Number formatting -> Custom; but when refresh the report, the decimals data display once more.
It seems that the excel formatting is superseded by Smartview datasource formatting.
Is there any way to ensure that the data formatting from Excel remains before and after the refresh of the report?
Thanks
NK
0