Displaying text for columns that return abbreviations

Question & Answer
1

I have a column that has abbreviations - for eg E should be Expense or R should be Revenue.
I would like to display the full name in the report , like Expense, Revenue etc.
I tried using calculated fields but didn’t work.
Thank you.

1 Like
2

Hi @gopinathpc - Can you please share some sample input and expected output. This will help community to provide you the right approach and solution.

Regards - Sanjeeb

1 Like
3

For example Column A values ("E’, “R”)

Need to display Column A values as “Expense”, “Revenue” in the QuickSight report.

1 Like
4

Hi @gopinathpc - Can you please create a calculated field with this logic.

ifelse({value} = 'E','Expense',{value} = 'R','Revenue','NA')

See the sample output below.

image
image888×373 8.2 KB

Regards - Sanjeeb

1 Like
5

Works perfectly!
Thanks a lot.

2 Likes
6

Thanks @gopinathpc . Can you please mark the suggestion as solution so that it can help other community member.

Have a great week ahead.

Regards - Sanjeeb

1 Like