Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙏🙏🙏
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
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
=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