Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Analytics data filter
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?