Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys,
The below is not working for me:
=Count( {<ALLWaiverAmount={'>0'}>} DISTINCT Enrolment.EMPLID)
I just want to count distinct enrollment.emplid if the allwaiver amount is >0
Could you please help?
Sorry man false alarm, my stupid brain was not working. All waiver is in negative values so I should use < not >.
Thanks for answering though 🙂
This expression looks correct and I was able to use it (changing the fields, of course) in one of my QVWs.
Double-check your expression for spelling and Uppercase/lowercase. Enrolment may be spelled incorrectly?
Sorry man false alarm, my stupid brain was not working. All waiver is in negative values so I should use < not >.
Thanks for answering though 🙂