Straight table count values

[#1]

Hi

I have a straight table in which i am calculating a count

My requirement is, if i have a value 1 in count it should show as 'Y'

My requirement is, if i have a value 0 in count it should show as 'N'

employee	status	count({<status=={'hold'>}>employee)	my expexted out put
aaaa	hold	1	y
bbb	un hold	0	n
ccc	hold	1	y
ddd	unhold	0	n

Thank you

[sunny_talwar · Accepted solution]

May be this:

Pick(Count({<status={'hold'>}>employee) + 1, 'n', 'y')

[#3]

Thank you so much Sunny