5 Replies Latest reply: Nov 20, 2016 9:20 PM by John Cavoulas RSS

    num format in expression ->display data in excel

    Андрей Шепель

      Colleagues, good day!

      I have some problem with export data and it's display in excel file.

       

      In same expression in QV pivot i calculate expr with manually setting format. (in one expr i calculate absolute values and percents.)

      For example: if(dim=1, num(count(sales)/count(Total sales), '###,#%'),

                                       num(count(sales)))

      when the data is exported to xls, excel file can't recognize number format of values and requests to change format:


      dsdsdsd.png

      Can i set manually format of data in expr to export data to excel in number format?

      Thanks.