Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
=count({<[Renuwel Date] = {">$(=[Renuwel Date](today()))"} >}[Renuwel Date])
Count(If(RenewalDate > Today(),1))
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 ?
Hi,
Try using this expression.
=Count({<[Renuwel Date]={">$(vA)"}>}[Renuwel Date])
Here vA is variable For Today's Date.
You may try this
Sum( If(RenewalDate > Today(), 1, 0) )
hi
count({<[KYC Renewal Date]={">$=Today()"} >} [KYC Renewal Date])
count({<[KYC Renewal Date]={">$(=Today())"> }[KYC Renewal Date])
Sorry my mistake:
=count({<[KYC Renewal Date] = {">$(=Date(today()))"} >}[KYC Renewal Date])
try this
=Count ({$< [Renuwel Date]= {">$(=Today())"}>}[Renuwel Date])