Hi,
I have the following IIf statement;
MarkupCost1: IIf([Markup]='',([Markup]*[GBPCost]),[PSP])
What am trying to do is if the [Markup] is blank then show the [PSP] value, but if the [Markup] is not blank then do the calculation ([Markup]*[GBPCost]).
The above IIf shows the [PSP] value when there is no data in [Markup] but when I enter data I get #Error in [MarkupCost1].
What am I doing wrong.
Thanks
Karl
I have the following IIf statement;
MarkupCost1: IIf([Markup]='',([Markup]*[GBPCost]),[PSP])
What am trying to do is if the [Markup] is blank then show the [PSP] value, but if the [Markup] is not blank then do the calculation ([Markup]*[GBPCost]).
The above IIf shows the [PSP] value when there is no data in [Markup] but when I enter data I get #Error in [MarkupCost1].
What am I doing wrong.
Thanks
Karl