Export to excel number format not working

[#1]

Hi,

This calculated dimension =aggr(sum(aggr(count(TranscriptCompletions),[Employee Id],[Course Number])), [Employee Id]) returns a value.

When I export this to excel, the exported value is in text format. I tried using NUM#() and NUM(), but it is still giving me issues.

Please suggest!

[CarlosAMonroy]

Hi Naveed,

Go to Settings -> Document Properties and under the 'Number' tab search for TranscriptCompletions field and set it to be number.

Hope that helps,

Carlos M

[el_aprendiz111]

Hi,

=aggr(sum(aggr(count(TranscriptCompletions),[Employee Id],[Course Number])), [Employee Id]) *1

[#4]

Tried it. Does not work.

[#5]

Does not work. Nice try though!