SUM(Projected Commission)-SUM(Actual Commission)
1 of 1 people found this helpful
sum(Projected commissions) -sum(Actual Commissions)
you need to aggregate the values then subtract
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.