How is this not working?
I suspect that you're running into a problem because the revenue field is a number and the campaign and name fields are strings. Also, the sample you give above doesn't show the table names of the fields (they're should be in the format of {table.fieldName} or
{@formulaName})
So, you need to convert the revenue to a string. The challenge with this is that you need to format it correctly in order to have the data in numerical order rather than string order. If you just use ToText({Comp_Revenue}) then you'll get this type of order:
1
111
12
2
21
etc.
So you need to right-pad the number with zeroes to have it in this order
001
012
111
002
021
In order to do this you need to know how many characters are in the maximum possible number. For example, if I had a field that was defined as Number(6,2) I would do the following:
right('000000' + ToText({Comp_Revenue}, 2), 6)
-Dell
Edited by hilfy - 11 Aug 2008 at 12:34pm
IP Logged
