My customer has given me a real challenge - how to store either a currency or percentage data type in same data field, plus distinguish between the difference when calculating totals. I have racked my brain and it keeps coming back this is not the best approach to store different data types in the same field. see attach for example of final document. I do have a separate field that identifies the field type (currency, pct)
To top it off the data will be based on several crosstab query results - see ee:
I am looking for the best approach to handling mix data types.