
Contributor
2021-08-17
07:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Item Last Price Paid
Hi All
I am trying to add a new calculated field to a table. I want to map in the most recent price paid for the previous year for all item numbers, so that I can calculate the monetary impact of any price increases/decreases.
i.e Item numbers current line price - Item number last price paid previous year (If no value is available for the previous year use the oldest price from the current year)
Is this possible?
Many Thanks
James
1 Reply

MVP
2021-08-17
08:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@JamesP can you share a sample data and the expected output ?
Regards,
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
