When I export the figures with percentage into Excel, it is shown as numberic format not percentage, how to handle it?
For example: if the figure is 10%, it is shown as 0.1 in Excel.
Solved! Go to Solution.
In which point in the application the data is converted to a percentage?
Is this done on the front-side in the graph using the formatting percentage?
text(precentagefield) makes a textfield of the precentage value ... it depends if it is a problem the excel field is a textfield instead of a numeric field 😉
Suppose that your expression (%) like this: (COLUMN(1) - COLUMN(2))/COLUMN(2)
Goto Number tab ==> Select on expression ==> choose Interger with format #,##0.00 and check on "Show in Percent(%)".
Let me know if this help you.