I cannot seem to get a simple division of two fields to work. What am I missing? My goal is to find the percent utilized. January hours scheduled divided by the total number of work hours in Jan. Both of these fields are themselves a calculated v...
They are not duplicated names.
The avail hours is not 0. This is the formula in that column - IF({WeeklyHours} =40, “176”, “120”) If weekly hours are equal to 40, then 176. Else 120. Is what I was going for. It does populate the right values.
Th...
The two fields are both formula fields - integer formatting. So the values are like 120/176. And really it should be (120/176)*100 = percentage
Can division be done on formula fields? How might I work around that if that’s the case?
Thanks!