Multiple if/then in one formula

[ForMe2]

How do I enter multiple conditions in one formula? Here is what I have. It only uses the last if/then in the formula.

if CStr({tbl_Item.Amount2})=" " and ({tbl_Promo.Scan}> {tbl_Item.Amount}) then
formula=({tbl_Item.Amount}*{tbl_Qty.Qty})
end if
If{tbl_Item.Amount}=CCur(0.00) then
formula=(({tbl_Promo.Scan}*{tbl_Qty.Qty})*CDbl ({tbl_Item.Amount2}))
end if
If CStr({tbl_Item.Amount2})=" " and ({tbl_Promo.Scan}<{tbl_Item.Amount}) then
formula=({tbl_Promo.Scan}*{tbl_Qty.Qty})
end if

 

[bdreed35]

You had 3 independent If statements there and it returns the results of the last one.
Try it this way:

if CStr({tbl_Item.Amount2})=" " and ({tbl_Promo.Scan}> {tbl_Item.Amount}) then
formula=({tbl_Item.Amount}*{tbl_Qty.Qty})
else
If{tbl_Item.Amount}=CCur(0.00) then
formula=(({tbl_Promo.Scan}*{tbl_Qty.Qty})*CDbl ({tbl_Item.Amount2}))
else
If CStr({tbl_Item.Amount2})=" " and ({tbl_Promo.Scan}<{tbl_Item.Amount}) then
formula=({tbl_Promo.Scan}*{tbl_Qty.Qty})
end if

~Brian

 

[ForMe2]

Thank you, but I tried that and it still only read the last if/then statement.

 

[Madawc]

I'd split out each test as a boolian, i.e.

CStr({tbl_Item.Amount2})=" " and ({tbl_Promo.Scan}> {tbl_Item.Amount})

This should say True or False if you put it beside your data, or in an extra detail section under your line. You may find your tests are failing.

I also don't see why you need formula= or end if. Is this crystal or SQL?

It also helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[ForMe2]

This is a SQL formula, but I can use the Crystal. Which one would you suggest?

 

[Madawc]

I use Crystal because I know it better. It's probably easier to write.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10