Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following data in my app (mockup):
I have to show the sum of hours for each month. But while doing so, I have to ignore the hours that the 'Contractor' ResourceType has charged on Project 'XX'.
On Project XX, 'Contractors' have charged 6 hours in Jan, 16 hours in Feb, and 13 Hours in Mar.
Therefore,
Totals Hours in Jan should be (49-6) = 43 Hours
Totals Hours in Feb should be (78-16) = 62 Hours
Totals Hours in Mar should be (59-13) = 46 Hours
What should be the syntax to filter out "Contractor' Hours from Project 'XX'?
Thanks in advance!
YASH
Hi,
I got the solution by summing up below 2 expressions. Not sure if there is any better solution for this.
sum({<ResourceType={'Employee'},Project={'XX'}>} Hours) + sum({<Project-={'XX'}>} Hours)
Attached is your updated qvw.
--Priya
You can try this
Sum({$-<ResourceType = {'Contractor'}, Project = {'XX'}>}Hours)