How to Create Flag for Description text Column

[shivika123]

I have data like below 

ID	Description
1	yes 100%
2	No
3	yes 100%
4	it was Compliant
1	Y it was

Need to create flag for Column Description where value is yes or y.

even what would be set analysis to only count Description where is yes or Y ?

[StarinieriG]

Hi

maybe you could use something like this

If(Upper(Left(Description,1))='Y','Y','N') AS FLAG

[shivika123]

what would be the set analysis ?

[StarinieriG]

Count ({<FLAG={'Y'}>} Description)

[shivika123]

without using flg column then write the set analysis 

[StarinieriG]

Count({<Description={'y*'}>}Description)