Hi Guru's,
I have a transaction workbook with only Inventory Cost revaluations. I need only the latest ICR record of the month.
this is the data set:
workbook is:
The data that is blurred out must only be the 'New unit Cost' of latest ICR record in that posting period (or in the month) and not the average of that posting period (or month).
So when there are 2 ICR transactions in April for the same item on the dates 1/4/2024 and 4/4/2024 I only want to see the data of the latest transaction, in this case 4/4/2024.
Is there a way to get this right in the Dataset or Workbook?
Saved search is also an option.
i've tried a formula:
max({custbody_schutte_icr_newunitcost}) KEEP(DENSE_RANK LAST ORDER BY case when ((to_char(to_date({TRANDATE}),'MM')) = '04') then {custbody_schutte_icr_newunitcost} else Null end)
But that not gives me the results I should expect.
Anyone an idea?
Thanks in advanced.