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?
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?
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 )
User | Count |
---|---|
38 | |
32 | |
30 | |
17 | |
16 |