Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Two things that i still don't find clear enough
1. is it possible to use "IF" inside the set expression of an aggregation (i.e. count,sum..etc.) for example: count( if(date>today(),date))
2. i would like to count the Users.KEY in case the sum of WasLoginPotential equals to the sum of WasLoggedIn
for example i have this table:
what you would recommend to do?
1) Definitely you can use it2) I wold prefer this way
Count({<Users.KEY = {"=Sum(WasLoginPotential)=Sum(WasLoggedIn)"}>} Users.KEY)