Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have some IDs and I want to show that values(ID) I am doing something like , If(D1> xyz and D2 < abc,ID) But I know this is wrong way. Can any1 tell me how to get IDs?
Could you explain a bit more with a sample data set may be?
Please share some sample data .... with expected output...
Usually what we do in such cases, Count(If(D1> xyz and D2 < abc,ID)) then result will be count(ID). But now I want to print all ID comes under dates D1 and D2.
This?
Concat(Distinct If(D1> xyz and D2 < abc,ID) , ',')
Thanks Tresesco, I will try.