Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Day Community we would like to do the following:
count Datefield1 -= Datefield2 DISTINCT on Field3
But we seem to be struggling with the correct syntax.
We want to count distinct Field3 where DateField1 is not equal to DateField2.
Your most urgent assistance is appreciated.
May be this:
Count(DISTINCT {<Field3 = {"=DateField1 <> DateField2"}>} Field3)
May be this:
Count(DISTINCT {<Field3 = {"=DateField1 <> DateField2"}>} Field3)
Thank you for your quick response, just to clarify in our example:
So basically if the two dates aren't equal count distinctly Field3.
Would your above example still apply?
Regards,
Heinrich
So just to make sure I understand. Each persion's id will only have a single Datefield1 and Datefield2 or can they have multiple values for Datefield1 and Datefield2?
It worked! Thank you so much!
Awesome