Hello Team,
I want to know can we perform arithmetic expressions on EnumList data Type, when multiple values are selected.
For Ex: I have one field by the name “Service Availed” with data type as “Enum List” and option A, Option B, Option C. Each having different prices.
Is it possible that when a user selects Option A & Option B, the prices of both are totaled and shown in the “Final Amount” field?
In the [Final Amount] column, please have an expression something like ’
IF( IN( “Option A”, [Service Availed]), 25 , 0)+
IF( IN( “Option B”, [Service Availed]), 50, 0)+
IF( IN( “Option C”, [Service Availed]), 75, 0)
Where 25, 50, 75 are prices for Option A, B and C respectively. If the options prices are in in some column, please use those column references in place of the absolute values.
Please share the column settings if the column [Prospective Service to be Availed]
I got it. The column type was Enum that’s why it was not working. Now its fine.
Thank you!
