I am trying to do something very simple which is to detect what value is selected in an enum field to be able to do a mathematical operation based on that data but I get an error (you can see it in the image). How do you work this type of operation with these fields?
Many thanks for your help
The enum values are 3 Expense, income and transfer
You are trying to compare text value with a list. It sounds your column type is an EnumList rather than Enum. If you want to keep EnumList, you need to use IF(IN("Gasto",[Tipo de operacion]),...)
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |