Child and Parent mixed level formula
We've come up against an issue we're struggling to resolve.
The situation is we have 1 Parent and 2 Children.
We have the TotalStaff at the Parent level.
Child 1 is prioritised and may require 60 of the staff to meet its SLAs - this is determined in a second line item.
What we would like to do is be able to calculate the staff available for Child 2 (and downstream calculations using this) defined as (PARENT - CHILD1)
We were trying to do something like the attached screenshot - alternatively feel free ot tell me this is wrong and there's a much better alternative!