If-Then-Else returning Zero 1

[BHERNANDEZ]

Help the slow-witted, please!

I have two fields in the same If-Then-Else Formula. The Order Type field has only two answers - C or O. If the Order Type is 'C', then the sales amount is a negative number. Vice versa for the 'O'. My formula has no errors, but returns a sales amount of 0.00. What can I do to fix this?

Formula:

If {Order Type} = "C" then
If {Order Type} = "O" then
{Sls Amt}
Else {sls amt}*-1

Bridget

 

[vidru]

If you know that Order Type will always be C or O, then try:

If {Order Type} = "C" then
{sls amt}*-1
Else
{Sls Amt}

-dave

 

[BHERNANDEZ]

Dave,

Thanks!!! I had that originally, but my last field was beside the Else. The formula was correct, but I received a Bad Formula Result error when I tried to preview my report. Your idea worked wonderfully and now I can see my figures!!! Thanks again!

Bridget

 

[chelseatech]

Slightly tidier to avoid a multiply operation and just change the sign with

If {Order Type} = "C" then
-{sls amt}
Else
{Sls Amt}


Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm