
1. Re: Calculate difference between two columns composed of sum number of records.
sam.hong.0 Mar 30, 2016 9:58 AM (in response to sam.hong.0)Has anybody tried this calculation?

3. Re: Calculate difference between two columns composed of sum number of records.
sam.hong.0 Mar 30, 2016 11:16 AM (in response to Mahfooj Khan)Hello Mahfooj,
Thank you for your response, however, that does not work necessarily.
I have attached a sample workbook, could you take a look again?
Thanks!

4. Re: Calculate difference between two columns composed of sum number of records.
Mahfooj Khan Mar 30, 2016 9:40 PM (in response to sam.hong.0)Do you mean to say the difference of records between item and furniture?
If yes then pls follow the difference calc field in the attached workbook. Else pls provide the expected output.
Mahfooj

5. Re: Calculate difference between two columns composed of sum number of records.
sam.hong.0 Mar 31, 2016 5:52 AM (in response to Mahfooj Khan)This is exactly what I was looking for!
Can you walk me through the formula?

6. Re: Calculate difference between two columns composed of sum number of records.
Mahfooj Khan Mar 31, 2016 9:43 PM (in response to sam.hong.0)2 of 2 people found this helpfulSure! My pleasure!
See this is the calculated field which I've used to calculate the difference.
Here,
ZN() function replace null to zero, If found.
LOOKUP() function is the interesting part which doing your job
In the Difference table calculation, we want to compare a value against itself in a previous (or simply, a different) partition. Notice how the second value in the calculation is wrapped in a LOOKUP() function, which "looks" at the previous partition's value and then subtracts it from the next one, etc. The 1 declares which partition is in relation to the base of the calculation.
Mahfooj