Set Analysis Today

[Arnaud35]

I have a problem with my script below :

=sum({<[Opportunite.Date_relance]={'$(='<='&Date(Today(),'DD/MM/YYYY'))'}>}[Opportunite.EstOpportunite])

It seems to be OK but it returns any result.

Thank you for your help 🙏🙏🙏

[AshutoshBhumkar · Accepted solution]

Hello,

It must be a date format issue. Check for the existing date format of Opportunite.Date_relance and try to match in set analysis.

Thanks,

Ashutosh

[Arnaud35]

Hi @AshutoshBhumkar 

The date format is as shown below

[vikasmahajan]

=sum( {1<[Opportunite.Date_relance] = {"<=$(=Date(Today(), 'MM/DD/YYYY'))"}>} [Opportunite.EstOpportunite])

or

Sum({<[Opportunite.Date_relance] = {'$(=Date(Today() - 1))'}  [Opportunite.EstOpportunite])

Hope this works for you

Vikas