Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to create a Year to date to show the number of projects done by each staff. I cannot get the expression correct.
Can anyone help to guide on this?
Thanks
Chun Wey
Can you attached sample of your data(not qvw)
Hi Robert,
thanks for your help.
Attached is the data.
Chun Wey
From which table(tab) in Excel file the count should be taken?
There is 9 different tabs
From the project tab, the count should be the no of project (p_id) done YTD.
Thanks for asking.
Create Straight Table.
Use p_id as Dimension and below formula as Expresion:
count({<p_actualenddate={"<=$(=Date(Today(), 'MM/DD/YYYY')& '>=' & '01/01/2015')"}>} p_actualenddate)