Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a pivot table with various numeric values, a few of which are formatted in currency and percentages. When I export the chart to excel these formats disappear. How can I maintain them? Here is the current syntax I"m using:
num(sum([Field 1]), '$##.##'),
num(sum([Field 3]) / sum([Field 4]), '#,##0.00%'),
try to set the number formatiing in number tab. This will be carried over to the export i guess.
or try to round it while loading, this would improve the performance also.
-Sundar