-
Re: Subtract Invoice amount from Total based on Status, in Parent-Child relationship
In case anyone is wondering, I found an answer in another post. My solution is =[Contract Amount]@row - SUMIFS(CHILDREN([Invoice Amount]@row), CHILDREN(Status@row), "Complete")1 ·