Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Enumerations in Reports

Avatar

Avatar
Validate 10
Level 2
Jaspreet_Kaur1
Level 2

Likes

9 likes

Total Posts

26 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 10
Level 2
Jaspreet_Kaur1
Level 2

Likes

9 likes

Total Posts

26 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 1
View profile
Jaspreet_Kaur1
Level 2

26-09-2017

Hello friends,

A very basic question:

I am building a report in AC and in Page activity I am trying to get the data of a column which is of type enumeration.

Instead of getting the label of the enumeration, I am getting its value.

For example : I am getting values like 0,1,2 instead of getting Approved, Rejected,Cancelled.

I have tried using Format = Enumeration in the cell format too, it fails to work and throws blank value in this case.

Can someone help pls?

View Entire Topic

Avatar

Avatar
Validate 10
Level 2
Jaspreet_Kaur1
Level 2

Likes

9 likes

Total Posts

26 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 10
Level 2
Jaspreet_Kaur1
Level 2

Likes

9 likes

Total Posts

26 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 1
View profile
Jaspreet_Kaur1
Level 2

27-09-2017

Thanks Jean for your inputs.Its helpful !

I was also trying to create an expression (CASE WHEN/IF) in the query activity(Just before the Page activity) while fetching this field, However, on doing so, the column is completely coming blank in the report.Unsure, why!

1311956_pastedImage_0.png

Can you name some standard factory reports where such case is handled, as you mentioned in your earlier reply, so that I can refer it?

Thanks,