formula will not gel 1

[patty1]

I have two formulas from two different reports that I have to get together into one formula - I know it sounds easy, but after 3 days of turning them inside out - I have given up. My results are either it omits all of "075" or counts only "075" regardless of what the name is...blah blah. I don't want to bore you with all the scenerios, if you just put it together the way you think it should go, maybe it will be a way I have not tried.

THanks alot for any help. By the way, there is a reason for the repetition in the second formula. If I don't do it that way, it brings in numbers I don't want.

FIRST FORMULA - 401K

if {Transaction_History.Fund} in "0100" to "0399"
and {Transaction_History.Trade_Type}='P'
and not ({Rep_Profile.Territory} in
["85", "89", "90", "88", "00"])
and(({Transaction_History.Social_Code} <> &quot;047&quot or
({Transaction_History.Social_Code} <> &quot;075&quot; and
{UNICMPNY.C_NAME} <> &quot;Fidelity Investment Advisor
Group&quot)
then {Transaction_History.Gross_Amount}

SECOND FORMULA - Mutual Funds

If (({Transaction_History.Fund} in &quot;0100&quot; to &quot;0399&quot
and not ({Rep_Profile.Territory} in
[&quot;00&quot;, &quot;85&quot;, &quot;88&quot;, &quot;89&quot;, &quot;90&quot;])
and {Transaction_History.Trade_Type}='P' )
or ({Transaction_History.Fund} = &quot;0744&quot;
and not ({Rep_Profile.Territory} in
[&quot;00&quot;, &quot;85&quot;, &quot;88&quot;, &quot;89&quot;, &quot;90&quot;])
and {Transaction_History.Trade_Type}='P' )
or ({Transaction_History.Dealer_Number} = &quot;40158&quot;
and {Rep_Profile.Territory} = &quot;00&quot
and {Transaction_History.Trade_Type}='P'
then {Transaction_History.Gross_Amount}

 

[kenhamady]

What happens if you create a 3rd formula that adds these two together? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[patty1]

Thanks - I knew I needed a fresh perspective!