Just a quick tip/fix for this problem. When exporting a report to excel, sometimes you'll end up getting a long text version of the number zero instead of the actual number -- causing issue and/or time correcting the issue for users.
The fix is simple, in this case, I just cast the numbers as decimal in my query forcing it to treat it as such. (ex: CAST(PCT AS DECIMAL) AS PCT )
No comments:
Post a Comment