4 Replies Latest reply on Jun 20, 2018 2:42 PM by Aradhana Lakshman

# Difference between two Values

I Have two fields: Projected Commission and Actual Commission. I am creating another calculate field(Named as forecasted commission here) for the difference between these two. As you see i the picture below the

simple calculation is returning the wrong value. The actual difference between 6,407,939.11 and 2,510,828.53 is 3,897,111. But the formula: Projected Commission - Actual Commission returns -189,597

• ###### 1. Re: Difference between two Values

SUM(Projected Commission)-SUM(Actual Commission)

• ###### 2. Re: Difference between two Values

Try

sum(Projected commissions) -sum(Actual Commissions)

you need to aggregate the values then subtract

Jim

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.

1 of 1 people found this helpful
• ###### 3. Re: Difference between two Values

Thanks!

• ###### 4. Re: Difference between two Values

Thanks!!