I have a report that has a crosstab on it. In this crosstab my summary field is a string and I'm doing a max for the summary function.
This works fine...the string allows my numeric data to have different formats (some columns have 4 decimals places others have 0, etc.)
This doesn't work fine when you try to export the report to Excel to do some custom analysis. The numbers come in as text so the user has to change them all to numbers manually.
So, in my genius...I thought I'd create a formula to convert the string field to a number and using the string I calculate the decimal places and rounding formats each field should have. Great!
But, now I learn there is some data in this string field that is not numeric, like what color a result was. They want this same data in the same crosstab. How can I manage this?
This works fine...the string allows my numeric data to have different formats (some columns have 4 decimals places others have 0, etc.)
This doesn't work fine when you try to export the report to Excel to do some custom analysis. The numbers come in as text so the user has to change them all to numbers manually.
So, in my genius...I thought I'd create a formula to convert the string field to a number and using the string I calculate the decimal places and rounding formats each field should have. Great!
But, now I learn there is some data in this string field that is not numeric, like what color a result was. They want this same data in the same crosstab. How can I manage this?