How to show text on the basis of condition??

[Anonymous]

Hi

I have created an employee report which has fields present and leave. I want the pivot to show "yes" or "no" for the condition if the employee is present or on leave. I am not getting how to show text on the basis of condition. please help..

[tresesco]

If present and leave are different fields, you might try something like:

If(present='Y', 'YES', 'NO')

Assuming your present field has flag value like Y/N

[#3]

hi, if you can attach an sample application it s better

[#4 · Accepted solution]

hi, I think this will help you

[#5]

Where do you want to show the Text?

if(present = 1,'YES','NO')

[Anonymous]

Thanks all