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.
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.
User | Count |
---|---|
33 | |
25 | |
23 | |
23 | |
15 |