Trying to sum by type

[frankone]

What I am trying to accomplish is to sum all credit card
types into one field, when I use the formula it also
included checks which I do not want. Each field(custivn.MethPay1) can have a different type of payment,.



IF {custinv.MethPay1} = "Amex" or {custinv.MethPay1} = "Master Card" or {custinv.MethPay1} = "Visa" or
{custinv.MethPay2} = "Amex" or {custinv.MethPay2} = "Master Card" or {custinv.MethPay2} = "Visa" or
{custinv.MethPay3} = "Amex" or {custinv.MethPay3} = "Master Card" or {custinv.MethPay3} = "Visa"


THEN Sum([{custinv.InvPaid1},{custinv.InvPaid2},{custinv.InvPaid3}])

ELSE 0

 

[synapsevampire]

Your formula is analyzing the current row only, not all rows.

Try creating 3 formulas of:

//@sm1
if {custinv.MethPay1} in ["Amex", "Master Card", "Visa"] then
{custinv.InvPaid1}
else
0

//@sm2
if {custinv.MethPay2} in ["Amex", "Master Card", "Visa"] then
{custinv.InvPaid2}
else
0

////@sm3
if {custinv.MethPay3} = in ["Amex", "Master Card", "Visa"] then
[{custinv.InvPaid3}
else
0

Then use a formula of:

sum({@sm1}+{@sm2}+{@sm3})

This assumes that the numbers at the end of the MethPay and the InvPaid correspond.

-k

 

[frankone]

This formula does not work I am using Ver 8.5 of crystal
The error message I get is "Remaining text does not
appear to be part of formula. This appears after
//@sm2

Thank You!

 

[synapsevampire]

There are 3 formulas, which isn't working?

At least take the time to post what you tried...

-k

 

[frankone]

Sorry! Here are the formulas I used
sm1
if {custinv.MethPay1} in ["Amex","Master Card","Visa"] then {custinv.InvPaid1}
else
0
I did the same for sm2 & sm3

then I set up sum123 formula

sum123
sum({@sum1}+{@sum2}+{@sum3})
this is where the following message occurs
"The Summary/Running total field count not created.

 

[lbass]

Use the following formula for a detail level sum (per row):

{@sum1}+{@sum2}+{@sum3}

Then you can right click on this and insert a summary (sum) at the group or report level.

-LB

 

[frankone]

I figured it out! Thank You for you help!