If then statment in Crystal reports V10 1

[Eddie920]

I am having a problem with the following formula:
if {@Sales tax}>0 then formula={STP_ProjectView.AmountBilled}-{@Sales tax} else formula={STP_ProjectView.AmountBilled}

The formuala is supposed to give me the price of a job less the sales tax if sales tax is part of the sales price.
The problem is the table that contains the sales tax does not contain all job numbers so when it looks for @Sales tax it finds nothing for those jobs so they are not included in my report. I need to know how to write the formula where it disregards the fact that the table has no value for sales tax for a job but still gives me a value. Hopefully this gives everyone enough information.

 

[DataDog]

This should do it:

if {@Sales tax}>0 then ({STP_ProjectView.AmountBilled}-{@Sales tax}) else {STP_ProjectView.AmountBilled}



DataDog
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?

 

[Eddie920]

I tried it but Crystal gives me an error and asks for a statement in front of the quotations.

 

[lbass]

Datadog is using Crystal syntax and you were using Basic syntax. Using Crystal syntax (this is an option in the formula expert), try this formula:

if not isnull({@salestax}) and
{@salestax} > 0 then
{STP_ProjectView.AmountBilled}-{@Sales tax} else
{STP_ProjectView.AmountBilled}

-LB

 

[Eddie920]

Thank you very much, that works. I didn't know you had the option of using Crystal or Basic syntax when writing formulas.