Logical help

[Anonymous]

Hi all,

I have field named  "CSS_CurrentCEScoreR"  which has range of number till 1000.I want to derive a new column from by arranging a range like 0-20,20-40 and so on from this field. I am using the Class function for this but still no data is populating. Can anyone help?

Regards

Adarsh

[Anil_Babu_Samineni]

May be do this

Class(CSS_CurrentCEScoreR,20) as CSS_CurrentCEScoreR1

[Anil_Babu_Samineni]

FYI, I used this

LOAD replace(class(RowNo(),20),'<= x <','-') as ID1 AutoGenerate 998;

Output:

[Peter_Cammaert]

In a User Interface expression, or in the Load script? You're not posting this in the Scripting forum, so I'm assuming you want to do this on-the-fly?

Can you post an small example document that shows this behavior?