topic Set Analysis Today in App Development

Set Analysis Today

Arnaud35 — Sat, 16 Nov 2024 16:53:31 GMT

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 — Fri, 03 Dec 2021 09:20:41 GMT

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 — Fri, 03 Dec 2021 09:30:31 GMT

The date format is as shown below

vikasmahajan — Fri, 03 Dec 2021 09:54:02 GMT

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

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

Hope this works for you

Vikas