This content has been marked as final. Show 6 replies
Lots of ways to achieve this, but best practice says, do the transformation in the script first, then your expressions in the front end are really simple.
T1: Load * inline [ CLI, Indicator 12345,1 1245698,1 124788,0 12369,1 12369874,1 ]; T2: Load *, IF(len(CLI)>=5,1,0) as Over5Flag Resident T1; Drop Table T1;
Then in a text box:
Hope this helps.