I have a report in which I need to return 0 for the price field if a couple of conditions are true, otherwise return the price.

I have got this code in the formula:
if ({vwSalesOrdersPrint.FollowUp_Action} = "To Follow") OR ({vwSalesOrdersPrint.NoCharge} = TRUE) THEN
    0
ELSE
    {vwSalesOrdersPrint.Price};

It is only returning 0 and not the price. Can some tell me what is wrong with the formula.

Thanks

Hi thanks for the reply.
However this is only returning 0 where {vwSalesOrdersPrint.FollowUp_Action} = "To Follow". All the rest are blank.

Hi kostya122
The records in the database can have one of the 3 conditions:
1. No charge items
2. FollowUp_Action = an action
3. everything else

IF either condition 1 or condition 2 is True, then 0 should be returned otherwise the price of the item should be returned.

Thanks for your help everyone. I resolved it by using this formula:
If {vwSalesOrdersPrint.NoCharge} = TRUE Then
    0
ELSE
    {vwSalesOrdersPrint.Price} ;

I then suppress the value if FollowUp_Action = "To Follow".

It does what I want it to do.