Hello!

I am running Macola ES as our ERP system.  I am trying to create a custom Order Entry bookings report.  I have created a formula that “tells” the report to make the unit price either a positive figure or negative figure based on its order type (Credit, Invoice, or Order) which changes based on order's invoice posting status.    

My problem is combining both sets of If statements.  Each set of three works on its own, just not together.  What command am I missing in between them?  I’ve tried OR, AND, ELSE.

Sorry if this is very basic.  Any help is appreciated!

if {oehdrhst_sql.orig_ord_type} = 'c' then {v_OEBOOKINGS.unit_price} * -1 else

if {oehdrhst_sql.orig_ord_type} = 'o' then {v_OEBOOKINGS.unit_price} * 1 else

if {oehdrhst_sql.orig_ord_type} = 'i' then {v_OEBOOKINGS.unit_price} * 1

(something missing here??)

if {oeordhdr_sql.ord_type} = 'c' then {v_OEBOOKINGS.unit_price} * -1 else

if {oeordhdr_sql.ord_type} = 'o' then {v_OEBOOKINGS.unit_price} * 1 else

if {oeordhdr_sql.ord_type} = 'i' then {v_OEBOOKINGS.unit_price} * 1

if {oehdrhst_sql.orig_ord_type} = 'c' and {oeordhdr_sql.ord_type} = 'c' then

{v_OEBOOKINGS.unit_price} * -1

else

{v_OEBOOKINGS.unit_price} * 1