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!
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!
