Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I use the 3 expressions below to give me a list of projects that are/were on going for 0-5 Days, 6-10 Days and 11+ Days.
SUM(IF(Today ()- [CREATE_DATE_DAY]<=5,1,0))
sum(If(Today ()-[CREATE_DATE_DAY]>=6 and Today ()-[CREATE_DATE_DAY]<11,1,0))
SUM(IF(Today()- [CREATE_DATE_DAY]>=11,1,0))
However I want to now limit this further so it only shows the above where the field ENTRY_STATUS = "Being Worked On". How would I add this into the above Expressions? Note I'm also happy to change the above to Set Analysis if that would be easier.
Thanks Guys,
May be this:
Sum({<ENTRY_STATUS = {'Being Worked On'}>} If(Today ()- [CREATE_DATE_DAY]<=5,1,0))
Sum({<ENTRY_STATUS = {'Being Worked On'}>} If(Today ()-[CREATE_DATE_DAY]>=6 and Today ()-[CREATE_DATE_DAY]<11,1,0))
Sum({<ENTRY_STATUS = {'Being Worked On'}>} If(Today()- [CREATE_DATE_DAY]>=11,1,0))
May be this:
Sum({<ENTRY_STATUS = {'Being Worked On'}>} If(Today ()- [CREATE_DATE_DAY]<=5,1,0))
Sum({<ENTRY_STATUS = {'Being Worked On'}>} If(Today ()-[CREATE_DATE_DAY]>=6 and Today ()-[CREATE_DATE_DAY]<11,1,0))
Sum({<ENTRY_STATUS = {'Being Worked On'}>} If(Today()- [CREATE_DATE_DAY]>=11,1,0))
Perfect, thank you