I have read almost every forum I could find trying to find an answer to my problem. I am using a group that is determinded by a parameter. However, the field I'm using for the group by has two different data types. About 9 of the options in the "IF" statement use the data type String while the last two are Numbers. It took me ab while, but I finally figured out that everything in the IF, THEN, ELSE statement had to be of the same data types. I have sucessfully figured out how to do the group on the Numbers by converting them to strings and then formating them to sort correctly.
i.e.
else if {?IN_GROUP_BY} = "$/MMB" then ToText ({@net_mmb}, "#########.##")
This works great for most of my issue. However, I do have some data that handles negative numbers. I cannot figure out if there is a way to be able to sort the number as a string and it handle the negatives correctly. Currently my values are coming back as
0
-.21
-.22
-.34
1.2 (ect.)
Does anyone know if there is a way to get this to sort correctly
-.34
-.22
-.21
0
1.2
ect.
I have been working on this for about 3 weeks now and I'm about at my wits end. Any adivce will be greatly appreciated
i.e.
else if {?IN_GROUP_BY} = "$/MMB" then ToText ({@net_mmb}, "#########.##")
This works great for most of my issue. However, I do have some data that handles negative numbers. I cannot figure out if there is a way to be able to sort the number as a string and it handle the negatives correctly. Currently my values are coming back as
0
-.21
-.22
-.34
1.2 (ect.)
Does anyone know if there is a way to get this to sort correctly
-.34
-.22
-.21
0
1.2
ect.
I have been working on this for about 3 weeks now and I'm about at my wits end. Any adivce will be greatly appreciated