Custom fields formula calculation
Hi
I've created two custom fields
- Product hours
- Hours not booked
Product hours is simply a field to be filled out with the total amount of hours available
Hours not booked is a formula [Product hours]-[Effort] to calculate how many of the total amount of hours are not already allocated in effort.
I just need the calculation on project level, so in this case 100h minus 22h30m.
It seems like the calculation is not quite right - what am I missing?
Maria Hermansen I recreated your scenario and played with it quite a bit.
The key item you need to change, you will where it says "Sum" in for field at the project level.
This should not be there. Click on Sum, then click on the X to delete it.
That Sum is causing it sum the children rather than do the calculation you want
Versus
Ped Watt Thanks a lot! makes perfect sense now that I see it 😮💨