Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
DipeshVadgama
Partner - Creator II
Partner - Creator II

Excluding NULL & -ve Values

Hi,

I am trying to do set analysis in Strange table to exclude date which are blank & Day Rem which are in negative.

=Count({<[User ID]={'=Len(Trim([Complete Date]))=0'},[Days Rem]={"<=0"}>}[User ID])

But in not get required result.

10 Replies
DipeshVadgama
Partner - Creator II
Partner - Creator II
Author

Oh my god, Thanks you. I did not realized that. Its works not.