I have a data element that is formatted as text. The are actually dollar values. I need to find a way to transform them in Cognos to be able to sort in value order, not text order so instead of:
$1,000,000
$5,000
$70,000
I need it to be:
$5,000
$70,000
$1,000,000
If I knew the list of values would always be static, I would create an item to number these values and sort them that way. However, a new one could pop up at any time. I know the easiest way is to go back and change the format in the model but that's not an option right now.
Any tips?
thanks
$1,000,000
$5,000
$70,000
I need it to be:
$5,000
$70,000
$1,000,000
If I knew the list of values would always be static, I would create an item to number these values and sort them that way. However, a new one could pop up at any time. I know the easiest way is to go back and change the format in the model but that's not an option right now.
Any tips?
thanks