Forum Discussion
AustinK
4 years agoQrew Commander
You could create a formula field on the table or even a report text formula that takes into account what is shown in your dropdown field. The problem is it is going to be awful to maintain this as it just text matches things. So when a new option is added to the dropdown you will also need to update the formula. Same if you change an option in the dropdown.
If(
[Dropdown] = "Earning", "E",
[Dropdown] = "Deduction", "D",
""
)
If(
[Dropdown] = "Earning", "E",
[Dropdown] = "Deduction", "D",
""
)