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 effecti...
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.