Hello,
I am creating a table which, in part, associates costs with certain items. So I built an expression to generate costs:
IIf([Unit]="Unit A", 15,0) & IIf([Unit]="Unit B", 17,0)
To make Unit A come up as $15.00 and Unit B come up as $17.00 and so on. It works well for all the items I have solid costs for, but the problem is that sometimes things are not so conveniently categorized. I'd like to include an option to select 'Unit' as "Other" and then allow the user to type in the value themselves. Is there a way to do this within a calculated field?
Thanks!
I am creating a table which, in part, associates costs with certain items. So I built an expression to generate costs:
IIf([Unit]="Unit A", 15,0) & IIf([Unit]="Unit B", 17,0)
To make Unit A come up as $15.00 and Unit B come up as $17.00 and so on. It works well for all the items I have solid costs for, but the problem is that sometimes things are not so conveniently categorized. I'd like to include an option to select 'Unit' as "Other" and then allow the user to type in the value themselves. Is there a way to do this within a calculated field?
Thanks!