num format in expression ->display data in excel

[Anonymous]

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:

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

Thanks.

[kuczynska]

Hi,

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.

[el_aprendiz111]

Hi,

Sometimes it happens, I solve it

(Expression)*1

[Anonymous]

Hi, of course, Expression Default is selected.

Don't understand what i must copy to what part of expr? Can you show in example?

Thanks.

[Anonymous]

Hi!

Thanks, dear.

But when i add *1 after all expression, some percent values was converted to simple integer..

[johnca]

Try setting the field value 'sales' to a number in the document properties.

HTH,

John