how to create a field based off other fields

[drohm002]

HI,

I have a field, LOS, that contains values 1 through 100.  I have another field that is a flag called, CC_FLAG.  The values is this field are 0,1, and 2.  I want to create a field that sums the LOS field when the CC_FLAG equals 1 or 2.  Please help!

[YoussefBelloum]

Hi,

you can try this on the script:

table:

load

.

.

if(match(CC_FLAG,'1','2'), LOS) as LOS_count

FROM...

then you can sum it on the front end

[sunny_talwar]

In the script? Or front end... for front end try this

Sum({<CC_FLAG = {1, 2}>}LOS)

[drohm002]

how about in the script?

[sunny_talwar]

May be this

LOAD Sum(LOS) as SumLOS

Resident ...

Where Match(CC_FLAG, 1, 2);