Hi,
I have created a simple report that outputs information from purchase orders based on an item code or a supplier and it gives me when,whom and when those items where purchased, with po number quantity and unit buying price.
What I would like to do is have a percentage increase/decrease value at the bottom by taking what the latest unit buying price and subtracting it from the earliest unit buying price and dividing it by the latest buying unit buying price.
Let me see if can build a table:
Supplier | Supplier Account Name | Document No | Document Date | Item Code | Item Description | Line Quantity | Unit Buying Price |
123 | Some Co | 000998 | 30/05/22 | 1234L | Part Number 1 | 40 | 24.19 |
123 | Some Co | 000997 | 30/04/22 | 1234L | Part Number 1 | 35 | 28.25 |
123 | Some Co | 000996 | 30/02/22 | 1234L | Part Number 1 | 18 | 28.24 |
123 | Some Co | 000950 | 30/01/22 | 1234L | Part Number 1 | 95 | 24.19 |
124 | Some Co 2 | 000940 | 30/12/21 | 1234L | Part Number 1 | 45 | 24.19 |
124 | Some Co 2 | 000900 | 30/10/22 | 1234L | Part Number 1 | 78 | 24.19 |
Total % inc/dec |
So in the "Total % inc/dec" cell, I would like the value of first - last / first so its expressed as a percentage. obviously this will 0% on this entry, but we have prices that have gone up and we would like to know by how much. I can do this in Excel easily enough, but want to try and achieve the same effect in Report Designer, I just don't know how expressions work.
Cheers....Derrick