HI, I have a report, that provides a list of products, quantities and prices.

In the footer of the report, I sum the total costs. I need a line item to be added IF a certain product was ordered.

So for example a person orders

2 pies -- $2.00
3 donuts -- $1.00
4 oranges -- $4.00

Sub Total -- $7.00
Orange Premium -- $2.00
Grand Total -- $9.00

If no oranges were ordered then the Orange Premium Line is Blank or $0.00.

I have tried IIF([field]="oranages", 2,0), but it does not work.

Help!