Can i properly place a IF within a compute stmt?

COMPUTE field1/D20.2 = (TOTAL_MISMATCHES / 308) * 100;

that "308" could be one of 3 values, depending on another column in the row. the above works, but only for 1 value (of course).

COMPUTE field1/D20.2 = (TOTAL_MISMATCHES / IF DIV = 'X' THEN 308 ELSE 444) * 100;

this give me an error on the "DIV" portion,

This message has been edited. Last edited by: FP Mod Chuck,

IF DIV EQ 'X' THEN (TOTAL_MISMATCHES/308 )*100 ELSE (TOTAL_MISMATCHES/444)*100;

https://webfocusinfocenter.inf...rce/CommandRef46.htm

This message has been edited. Last edited by: BabakNYC,

BSBAL18, I think you may need some training.

Or you could do another compute first.

COMPUTE DIVISOR1/D3=IF DIV EQ 'X' THEN 308 ELSE 444;
COMPUTE field1/D20.2 = (TOTAL_MISMATCHES/DIVISOR1) * 100;