Hi all,
I use calculated field in table with formula, but result is not true :
=IIf([amount]<"1000",[price],[amount]*[price])
when I type value less than "1000" in [amount] it gives [amount]*[price], while if [amount] be less than "1000" The field must gives [price]
for every number in amount it only gives [amount]*[price].
Can someone tell me problem of code?
I use calculated field in table with formula, but result is not true :
=IIf([amount]<"1000",[price],[amount]*[price])
when I type value less than "1000" in [amount] it gives [amount]*[price], while if [amount] be less than "1000" The field must gives [price]
for every number in amount it only gives [amount]*[price].
Can someone tell me problem of code?