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,

[vijetas42]

Hi,

You can write expression as If(Renuwel Date>today,count(Renuwel Date))

Thanks!

[cesaraccardi]

Hi,

First you have to make sure the date field is being loaded correctly, you can use Date#()  function to specify the date formatting that is coming from the data. Then on the expression a simple num(Today()) should work.

See image below,

Cesar

[MarcoWedel]

Hi,

another solution could be:

=-Sum([KYC Renewal Date]>Today())

Although the already suggested set expression

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

should have the better performance.

hope this helps

regards

Marco