Summary formula help

[RavenXIII]

Hi im fairly new to crystal im using 8.5 and iv been trying to get a formula that does this

sum (EV_BOOKING:TOTALPRICE)
Where EV_BOOKING.BOOKINGSTATUS = "CFM"
+
Sum (EV_BOOKING.CANCELLATIONFEE)
Where {EV_BOOKING.BOOKINGSTATUS} = "X"

Can someone Please Help


Thankyou

 

[dgillz]

This is going to take 3 formulas:

if {EV_BOOKING.BOOKINGSTATUS} in "CFM" then {EV_BOOKING:TOTALPRICE} else 0

if {EV_BOOKING.BOOKINGSTATUS} in "CFM" then {EV_BOOKING.CANCELLATIONFEE) else 0

Sum({@formula1})+sum({@formula2})


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[RavenXIII]

Thanks That worked great