Send to Excel - Calculated Dimension sending as Text instead of Number

[stubarnes]

Hi, I have a simple calculated dimension =year(Date) that is converted to text when sending to Excel.

I have checked multiple other posts on this and I have tried various formulas Num(), Round(,), year()*1, etc...

I have set ExcelExportMixedAsText to 0 and reloaded

All to no resolve, any ideas?

For info, I'm using QV 11.2 and Excel 2010

[rubenmarin]

Hi, create the field Year from Date in script, using this field should be exported as a number

LOAD ...

  Date,

  Year(Date) as Year

  ...

[Brett_Bleess]

You did not state which SR you are running in the 11.20 track, if you are not on SR13 or later, I would recommend trying the latest SR, which is 19, the full build number is 11.20.13804.  

If that does not help, if you can attach a sample app we can use to test things, we can confirm if we are able to replicate the issue or not.

Regards,
Brett