Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hey all hope you can help my problem is the following:
User | Renewal Date | RM Party |
ACHARBELXC | 2/1/2016 | 1 |
ACHARBELXC | 7/1/2016 | 2 |
ACHARBELXC | 7/1/2016 | 1 |
ACHARBELXC | 5/1/2018 | 1 |
ACHARBELXC | 10/1/2015 | 1 |
ACHARBELXC | 10/1/2015 | 2 |
ACHARBELXC | 9/1/2015 | 1 |
ACHARBELXC | 9/1/2016 | 2 |
ACHARBELXC | 9/1/2015 | 1 |
ACHARBELXC | 9/1/2015 | 2 |
ACHARBELXC | 9/1/2015 | 2 |
ACHARBELXC | 1/1/2020 | 1 |
ACHARBELXC | 11/1/2016 | 1 |
ACHARBELXC | 1/1/2017 | 1 |
ACHARBELXC | 12/1/2016 | 1 |
ACHARBELXC | 11/1/2015 | 1 |
ACHARBELXC | 1 | |
ACHARBELXC | 11/1/2015 | 1 |
ACHARBELXC | 10/1/2015 | 1 |
ACHARBELXC | 11/1/2015 | 2 |
Renewal Date type is number i need to count the Renewal Date > today() and ofcaurse i dont want to count the empty field
Count( {<Renewal Date > today()>}Renewal Date)
how can i wirte it in a correct way please help,
first you need to load your date column as date
Date(]Renewal Date]) as [Renewal Date]
then
if (len([Renewal Date] )>0,count({<[Renewal Date]>={Today(0)}>}[Renewal Date]))
Thanks
BKC
Hi,
try below
Count( {<[Renewal Date] ={">(=today())"}>}Renewal Date)
Note: carefull with date format
Regards
Hi,
USe distinct if you need distinct Count
Count( {<[Renewal Date] ={">(=today())"}>}DISTINCT [Renewal Date])
Regards
Hi..
Please find the attached qvw below.
Hope this will help you.
Thanks