I have a report that has several numerical fields. To fill a project requirement, i had to use the following formula:
if {DataTable1.No of Investments}>9999 then '*****' else toText({DataTable1.No of Investments},0)
Basically, if the number fed in is bigger than 9999 it turns into * on the report.
Now, when i try to export into excel, not only is the data type for all fields, strings...but the * show up versus numbers.
I was wondering if there was a way to re-cast this back into a numerical value SOLELY for the purpose of excel exportation so that i'd be able to use excel formulas as well as see numbers instead of asterisks. I'd only be doing data-only excel exports.
Any ideas?