Forum Discussion
Writing a Measure with a Cap
I am trying to write a measure for project cost, but I would like it with a max hour cap per month.
Worker A and B each salaried employees and over 2080 possible hours in a year have an effective cost $100/hr, August has 176 possible billable hours.
Worker A works 75 hours = 75 X 100 = Project cost of $7500
Worker B works 204 hours = 176 X 100 = Project cost of $17,600
While the revenue for Worker B would be based on 204, I would like the cap to be on the monthly possible hours as that person's cost for a month would not increase based on how many hours they billed since they are salaried.
Can anyone help with this? Happy to clarify if this doesn't make sense.
3 Replies
Would something like this work?
capped = IF(SUM(hoursworked) > 176, 176 * 100, SUM(hoursworked))The complexity is I have 30 workers with their different cost rates and each month has varying possible billable hours depending on how many weekdays in the month so I can't hard code each workers cost amount or each months possible hours.
That makes sense. I'm assuming you have both of those fields already in the daaset? If so, you should be able to just switch them out in the formula above.
