I am on Dev Studio 7.6.10. I want to do a define on a table. If I do a selection on a single value, then it works (PERC_TEMP). If I do a selection on multiple values, then I get the above error message (FUND). Example below:

DEFINE FILE PHRELBD
PERC_TEMP/D12.2=IF PHRELBD.PHRELBD.PHRELBD_FUND_CODE EQ PHRELBD.PHRELBD.PHRELBD_FUND_CODE THEN (PHRELBD.PHRELBD.PHRELBD_PERCENT / 100) ELSE 0;
FUND/D12.2=IF PHRELBD.PHRELBD.PHRELBD_FUND_CODE EQ &PHRELBD_FUND_CODE.(OR(FIND PHRELBD_FUND_CODE IN PHRELBD)).FUND. THEN PHRELBD.PHRELBD.PHRELBD_PERCENT ELSE 0;
END

Please help.
Thanks

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

Here's the working example with CAR,

DEFINE FILE CAR
CAR1/A10 = IF CAR EQ &CAR.(OR(FIND CAR IN CAR)).CAR. THEN 'AAAA' ELSE 'BBB';
END
TABLE FILE CAR
PRINT
CAR
CAR1
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
END

-Hari

Hari,

Thank you for your sample code. Yes, it is working for me now.

Thanks,
Steven