1 Reply Latest reply: Aug 18, 2015 8:58 AM by Sundarakumar Kalaimani RSS

    Issues export currency and percentage formats in excel

    Lin Yur

      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%'),