I have 2 formula's in my crystal report. One of them decides what gifttype to use and the other decides if they are part of a certain group with a yes or no. If I just have output id and Formula 1 then my gift calculations are correct.

If I just have id and formula 2 then my formula 2 yes and no's are correct.

If I try to use both formula's then formula 2 yes and no's are correct but formula 1 gift calculations are multiplied by the total amount of attrtypes the id has associated with them, even if they are not one of the selected yes's.


Formula 1 (which is summed)

If {GIFT_TYPES.TABLE_CODE} = "g" then {GIFTS_FULL.GIFTAMOUNT}
else if {GIFT_TYPES.TABLE_CODE} = "c" then {GIFTS_FULL.GIFTAMOUNT}
else if {GIFT_TYPES.TABLE_CODE} = "p" then {GIFTS_FULL.GIFTAMTPLG}
else if {GIFT_TYPES.TABLE_CODE} = "e" then {GIFTS_FULL.GIFTAMTPLG}
else if {GIFT_TYPES.TABLE_CODE} = "r" then {GIFTS_FULL.GIFTAMTPLG}
else 0

Formula 2:

If ({attribute_full.attrtype} = "LSVT" or {attribute_full.attrtype} = "BVC" or {attribute_full.attrtype} = "SVC"
     or {attribute_full.attrtype} = "EVC" or {attribute_full.attrtype} = "ENVC" or {attribute_full.attrtype} = "AVC"
     or {attribute_full.attrtype} = "ASVC" or {attribute_full.attrtype} = "SVC" or {attribute_full.attrtype} = "UVC"
     or {attribute_full.attrtype} = "VCCE" or {attribute_full.attrtype} = "BOT" or {attribute_full.attrtype} = "FBoD"
    ) then 'Y' else 'N'

Right now they are all set at not enforced.
My joins are left outer joins from a basic table to both the attribute_full and gifts_full table.

I enforced all the joins and am still having the problem. Help!