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? 

 

 

 

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
3 comments

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

 

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Versus

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Ped Watt Thanks a lot! makes perfect sense now that I see it 😮‍💨

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Custom fields formula calculation
[this list is visible for admins and agents only]

Top
Didn’t find what you were looking for? Write new post