Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to take out percentage of date values which are less than today's date against total number of project count using Set expression.
I tried this :
=Count({$<([Launch Date])<{">=$(=Date(Today(), 'YYYY-MM-DD'))"}>}) / Count(DISTINCT ProjectID)
But this is throwing error.
Any help appreciated. Thanks in advance.
Regards,
Shubhangi
Hi,
you forgot to mention [Launch Date],
but if I add the file header, the loading script:
so, the funcion becomes
='count of Launch date which are less than todays date :'& count({<"Date([Launch date])" = {"<=$(=MakeDate(Year(Today()),Month(Today()),Day(Today())) )"}> } Code)
and the result :
but be careful with null dates
Cheers,
Taoufiq
I think you forgot the measure: "count" of what? in Count({$<([Launch Date])<{">=$(=Date(Today(), 'YYYY-MM-DD'))"}>})
Taoufiq
Hi,
I want count of Launch date which are less than today's date.
Can you help me in forming the expression?
Thanks in advance.
Regards,
Shubhangi
can you share the sample data
Hi,
Please find the attached Sample data file.
Thanks,
Shubhangi
Hi,
you forgot to mention [Launch Date],
but if I add the file header, the loading script:
so, the funcion becomes
='count of Launch date which are less than todays date :'& count({<"Date([Launch date])" = {"<=$(=MakeDate(Year(Today()),Month(Today()),Day(Today())) )"}> } Code)
and the result :
but be careful with null dates
Cheers,
Taoufiq
Did Taoufiq's last post get you what you needed? If so, do not forget to come back to the thread and use the Accept as Solution button on that post to give him credit for the assistance and let other Community Members know it worked. If you are still working on things, leave an update as to what you still need.
Regards,
Brett