Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
Pick(Count({<status={'hold'>}>employee) + 1, 'n', 'y')
Thank you so much Sunny