Has anybody tried this calculation?
Thank you for your response, however, that does not work necessarily.
I have attached a sample workbook, could you take a look again?
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.
This is exactly what I was looking for!
Can you walk me through the formula?
3 of 3 people found this helpful
Sure! My pleasure!
See this is the calculated field which I've used to calculate the difference.
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.