topic Create Variable - IF Statement - other method? in App Development

Create Variable - IF Statement - other method?

jerryr125 — Sat, 21 Nov 2020 10:44:58 GMT

Hi -

Seems like a simple question but I might be overlooking something.

I am creating the following variable:

vProfit

My expression is :

=IF(ProductProfitID=1,2.5,IF(ProductProfitID=2,3.25,4))

Is there another method / function I can do in which assign a value to the vProfit based upon the ProductProfitID

(ProductProfitID can be 1,2,3 or 4) ?

- Jerry

rubenmarin — Sat, 21 Nov 2020 11:22:37 GMT

Hi @jerryr125, you can also use Pick():

Pick(ProductProfitID ,2.5 ,3.25 ,//value for 3 ,//value for 4 )

jerryr125 — Fri, 27 Nov 2020 14:22:32 GMT

Works - thank you

NUM#(PICK(ProductProfitID,45,25,35,80),'#0.00')