Hello,
Having trouble figuring out the best way to 1) get the difference between the 2 most current records within a group and 2) calculate the difference displayed as a percentage.
The data is Grouped by Item and Sorted by Date Descending
For Instance:
Item Group A
15 10/10/2011
43 10/08/2011
22 09/28/2011
Item Group B
0 10/12/2011
21 09/02/2011
11 08/25/2011
I created 2 formula fields:
Current ---> {InventoryActPkgCostHist.ActPkgCost}
Previous --> previous({InventoryActPkgCostHist.ActPkgCost})
Then created a 3rd formula field for percentage:
Percentage -->
But I am getting a divison by zero error. How can I get around this?
I am definitely not an expert and am not sure if I am in the right path for what I am trying to accomplish, any guidance would be greatly appreciated.
IP Logged
