Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to calculate how many days in the current month have a [Visit_ID] of 4 but i can't seem to find the answer.
Can anyone help please?
Hi
Try like this
Count({<Visit_ID = {4}, Month={'$(=Month(Today()))'}>} Days)
Hi, thanks,I don't have a field for Days, and the month needs to be taken from a date field..
here is what i want in a bit more detail...
i want to see which salesmen have worked full or half day.
A full days work is equal to them doing 4 visits, and a half day is them doing 2 visits per day..
I have attached a sample..
so what i want is a variable to show if the salesman have done a full days work (4 visits) or half days work (2 visits) for the current month
Does anyone know the answer to this?
Hi Try this:
Create a simple table with the dimensions:
then add the next expression:
So you will have days worked by Salesman and by month.
I attached the .qvw with the example.
count( {$ <Date={">=$(=MonthStart(Today()))<=$(=MonthEnd(Today()))"}> } Visit_ID) / 4