I want the Record Selection to add the Quantity the corresponds to the SDCODEs as follows: SDCODE(1+5+9-11). Below is what I have. It works great but the only part that doesn't work is the last portion {STKDET.SDCODE}= 11 . The formula below is ADDING the SDCODE 11 and not subtracting it. Can this be done?

Record Selection:
{STKDET.SDSTK} = {?Stock#} and
if({STKDET.SDSTK}={?StockException})then
{STKDET.SDCODE}= 1 or{STKDET.SDCODE}= 5 or {STKDET.SDCODE}= 9 or {STKDET.SDCODE}= 11 else
{STKDET.SDCODE} = 10.00

Selection formulas act as filters.
They are passed to the DB as part of the query that crystal builds.

Use a normal formula to write your code and then drag that onto the report instead if you want to customize your output.

Edited by Keikoku - 19 Apr 2011 at 8:41am