This content has been marked as final. Show 5 replies
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?