calculated field

[macattack03]

If i have a price of an item and i want to make another field in a report to meet a specific criteria how would i go about doing this



if items price is greater than 20 than discount it by 4% if its < 20 than only 2 % but i dont want to show the discount i want to show the sale price

here is what i came up with does this look close

=iif[price],>20*0.04,<20 * 0.02) but its showing up like the discount from the price instead of the total like for example 15.00 * 0.04 is .060 discount but i want it to show 14.40 instead

[ssanfu]

Maybe try:

=iif([price]>20, [price]*0.04, [price] * 0.02)

[macattack03]

I have attached just the report but the code you provided is doing the same thing

[ssanfu]

Oops sorry....

You can take the discount amount and subtract it from the price:

=[price] - iif([price]>20, [price]*0.04, [price] * 0.02)

or

you can use the percentages.. .04 discount is the same as multiplying by .96...

= iif([price]>20, [price]*0.96, [price] * 0.98)

[macattack03]

Steve,

Thanks this worked great. I need something similar to this but the criteria is a date how would i make an expression for a specific date

if item has a date posted march 4, 2012 > then discount by 0.03%, if <march 4 2012 then 0.05% discount on the price

[macattack03]

IIF function similar to the other one your helped me with

I'm referring to my book and another report I have created but its stating that it has to many arguments or something as the error message I think I'm really close
=[Date Posted]>Date(3/4/2012),[Price]-[price]*0.03,[Price]-[price]*0.05

if the date posted is > date(3/4/2012) then Price- price *0.03 if not then price-price*0.05

I can say it but just dont know where I'm going wrong

[alansidman]

=IIF([Date Posted]>#3/4/2012#,[Price]-([price]*0.03),[Price]-([price]*0.05))

Try this.