Script

[mario-sarkis]

Hey Guyz ,

I need Help here is my Question

i have a field for example

Renuwel Date

5/25/2015

4/31/2015

3/12/2015

i need to calculate the number of  Renuwel Date > today

count(Renuwel Date)>today

How can i write this in a set analysis

Thank you,

[robert_mika]

=count({<[Renuwel Date] = {">$(=[Renuwel Date](today()))"} >}[Renuwel Date])

[anbu1984]

Count(If(RenewalDate > Today(),1))

[mario-sarkis]

hi Robert i wrote it like this didn't work

count({<[KYC Renewal Date]={">$=Today()"}[KYC Renewal Date])

it didnt work where is my mistake ? can you help ?

[prajapatiamar38]

Hi,

Try using this expression.

=Count({<[Renuwel Date]={">$(vA)"}>}[Renuwel Date])

Here vA is variable For Today's Date.

[nagaiank]

You may try this

Sum( If(RenewalDate > Today(), 1, 0) )

[t_moutault]

hi

count({<[KYC Renewal Date]={">$=Today()"} >} [KYC Renewal Date])

[anbu1984]

count({<[KYC Renewal Date]={">$(=Today())"> }[KYC Renewal Date])

[robert_mika]

Sorry my mistake:

=count({<[KYC Renewal Date] = {">$(=Date(today()))"} >}[KYC Renewal Date])

[Anonymous]

try  this

=Count ({$< [Renuwel Date]= {">$(=Today())"}>}[Renuwel Date])