Getting a value from specific ENUMLIST data

[JpChapron]

Hi All,

I have an Enum list that contains 3 values, item 1, item 2 and item 3

What I want the functionnality to be is that I want to be able to select the items, and depending on which is selected, give a Price value to another collumn,

Here's the formula that i've tried (That didn't work obviously..!) in the Price collumn i'm trying to create:

IFS(
IN("Item 1",[dailyExpense_enumList]),10,
IN("item 2",[dailyExpense_enumList]),15,
IN("item 3",[dailyExpense_enumList]),20
)

That will work only if 1 item is selected, but I'm trying to set items to have prices linked to it

I know I could create a table with the associated items, but I want the functionality to be an enumlist, and not a list of items to be added

thanks for your help !

[Suvrutt_Gurjar · Accepted solution]

If understanding of your requirement is correct, please try

IFS(IN("Item 1",[dailyExpense_enumList]),10) +
IFS(IN("Item 2",[dailyExpense_enumList]),15) +
IFS(IN("Item 3",[dailyExpense_enumList]),20)

[JpChapron]

Thanks Suvrutt ! it works !