0
Relationship between "Chice" and "Formula" fields
The table has two fields, a choice "Category" and a formula field "Discount" . Depending on the client category, a discount is assigned. Can someone, please, tell me the formula, for example, when the category is 1 or 2, the discount is 10%, when the category is 3 or 4 - 15%, 5 - 20%
Regards
5 replies
-
You can try this in your formula field "Discount":
switch true do case Choice = 1 or Choice = 2: 0.1 case Choice = 3 or Choice = 4: 0.15 case Choice = 5: 0.2 end
You can change the number to text "10%" if you want. If you leave it as a number then you can quickly use it in other formulas.
You can check out this post for more background info and more examples of what you can do from Jacques TUR .
-
You can also use a table with all possible discount rates according to the category number:
item([0, 0.1, 0.1, 0.15, 0.15, 0.2],Number(category))
Content aside
- Status Answered
- 2 yrs agoLast active
- 5Replies
- 59Views
-
3
Following