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), '###,#%'),
when the data is exported to xls, excel file can't recognize number format of values and requests to change format:
Can i set manually format of data in expr to export data to excel in number format?
Are you sure that "Expression Default" option is selected for this expression on Number tab in object properties?
Also make sure that the "else" part of your statement has a correct number format set, i.e. copy '###,#%' to that part too.