set analysis

[mario-sarkis]

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,

[Anonymous]

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

[PrashantSangle]

Hi,

try below

Count( {<[Renewal Date] ={">(=today())"}>}Renewal Date)

Note: carefull with date format

Regards

[PrashantSangle]

Hi,

USe distinct if you need distinct Count

Count( {<[Renewal Date] ={">(=today())"}>}DISTINCT [Renewal Date])

Regards

[prajapatiamar38]

Hi..

Please find the attached qvw below.

Hope this will help you.

Thanks