topic Re: How to Create Flag for Description text Column in App Development

How to Create Flag for Description text Column

shivika123 — Wed, 22 Dec 2021 20:18:50 GMT

I have data like below

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 — Tue, 10 Sep 2019 10:05:07 GMT

maybe you could use something like this

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

shivika123 — Tue, 10 Sep 2019 10:18:17 GMT

what would be the set analysis ?

StarinieriG — Tue, 10 Sep 2019 10:20:21 GMT

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

shivika123 — Tue, 10 Sep 2019 12:11:32 GMT

without using flg column then write the set analysis

StarinieriG — Thu, 12 Sep 2019 14:10:17 GMT

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