Cant use self created column in multibox

[#1]

Dear all,

I have created a runtime column in the script. But i can't use it to filter the data when i put this column in the multibox. It allowed me to choose, but the value wouldn't changes. The following code is in my script. The row highlighted in red is my new column created during script load. Hope someone could help

Directory;

LOAD YEAR,

     Month,

     CustNo,

     Customer,

     Contract,

     [Avg EBIT],

     [FCast EBIT],

     LAB,

     MAT,

     ODC,

     [Act Sales],

     COGS,

     Profit,

     Margin,

     TotHrs,              

     AvgSales,

     Jobs,         

     AC,              

     ACDesc,

     CustNo & '-'  &  Contract as CContract,

     ceil(Month/3) as Quarter,

    if(SubStringCount(ACDesc,'BOE')=1,'BONG',(if(SubStringCount(ACDesc,'AIR')=1,'BUS','OTHERS'))) as ACType

FROM

DATA\profitreview.txt

(txt, codepage is 1252, embedded labels, delimiter is ';', msq)

where Left(Jobs,1)='2';

[tresesco · Accepted solution]

So tried this expression for multibox field?

=if(SubStringCount(ACDesc,'BOE')=1,'BONG',(if(SubStringCount(ACDesc,'AIR')=1,'BUS','OTHERS')))

// without the 'AS ..' part