Using an enumlist to add values to a subtotal

Hi, I’m trying to use an enumlist that will let me add on to a sub total. For example add services to an order. Is there a way to do this? I’ve thought about using an IF statement but unsure how to write it.

Thanks in advance.

0 4 407
4 REPLIES 4

You would like to calculate the total depending what services you have chosen with an EnumList column?

Yes, for example, im trying to work on an order form for my business and I need to add services like:
Uplift old flooring,
Dispose of old flooring,
Stairs surcharge,
etc…

How can I assign a value to these and then add the total of all the ones that are selected to a sub total at the end of the form?

Thanks.

You could do that like…
IFS(IN(“Uplift old flooring”,[EnumListName]),128.50)+
IFS(IN(“Dispose of old flooring”,[EnumListName]),96.40)+
Etc…

I’ll have a look at that and give it a try, thanks for the help.

Top Labels in this Space