multiplication expression in appsheet

[bakhodir97]

I am creating an app for private school.

I hava a discounts table, which includes 5 type of discounts.

In a registration table, in column Discounts [column type is EnumList, because we will have up to 3 types of discounts] I should include discounts and multiply the amounts of selected discounts.

Is it possible?

@Steve 

[Marc_Dillon]

So you need to apply up to 3 discounts, from an enumlist, to another value? Are the discounts additive or multiplicative? I.e. do 2 10% discounts on $100 equal $80 (100*0.8 ), or $81 (100*0.9*0.9) ? What is the base type of the enumlist, percent or ref?

[Marc_Dillon]

You'd need something like this either way:

[value]
*
IF( COUNT([enumlist]) > 0 , INDEX( [enumlist] , 1 ) , 1 )
?
IF( COUNT([enumlist]) > 1 , INDEX( [enumlist] , 2 ) , 1 )
?
IF( COUNT([enumlist]) > 2 , INDEX( [enumlist] , 3 ) , 1 )