Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Hi,
=aggr(sum(aggr(count(TranscriptCompletions),[Employee Id],[Course Number])), [Employee Id]) *1
Tried it. Does not work.
Does not work. Nice try though!