Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to do and/or operations in set analysis . Code is following:
Count(
{<CurrYear_flag={'Y'} , Prev1Year_flag={'Y'}, Prev2Year_flag={'Y'}>} +
{<CurrYear_flag={'Y'},Prev1Year_flag={'Y'},Prev2Year_flag -={'Y'}> }+
{<CurrYear_flag={'Y'},Prev1Year_flag -={'Y'},Prev2Year_flag={'Y'}>}
distinct ACCOUNT)
Can you please let me know right syntax to do this. only first set {<CurrYear_flag={'Y'} , Prev1Year_flag={'Y'}, Prev2Year_flag={'Y'}>} is working. Rest 2 are giving 0 in results. Prev2Year_flag -={'Y'} is not working I try individually. It has data Y, - . I am looking for not 'Y' data. It is not working with Prev2Year_flag ={'-'} too
Thanks,
Akanksha
Awesome! its working now.
Can you please explain logic of " being used here
Logic of "?
double quotes used
Just the way search string works... look here: