It appears your {Unit Value Amount_USD} is using an aggregation function (SUM ?). Looking at your requirement it seems you could put your rows at the lowest level into these different brackets and your calculated field in that can be just the value at the lowest level.
Alternatively, you may need to use Level Aware Calculations to get the computations return a value at the row level.