AgingRapidly
New Member
- Joined
- May 31, 2018
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
Have query for 2022 Receipts. Want to add date col to the PVT showing date if red'd w/i last 4 days & qty col showing qty rec'd on that date. Can be more than 1 receipt entry for an item on a date. Rec'd product must be tested prior to shipping, so need to add another col for Anticipated Release Date adding a number of days based on the day of wk rec'd.
Tried calculated col & measures--yet to find solution. Added Date_Diff calc col to 2022 Receipts thinking could be used in measure.
Some Transaction Date entries have date beyond today (entry errors). 2 rows per instance--1 data entered; 1 entry reversed. Filtered Date_Diff col to values > 0 to avoid them.
Created Prior to Today measure - TODAY()-4.
Attempted measure to return Transaction Date if it is <= 4 days from TODAY().
When Transaction Quantity added to PVT, number doesn't match qty for Transaction Date.
I feel like I'm close, but I can't work it out. Any assistance will be greatly appreciated. Thank you
Tried calculated col & measures--yet to find solution. Added Date_Diff calc col to 2022 Receipts thinking could be used in measure.
Some Transaction Date entries have date beyond today (entry errors). 2 rows per instance--1 data entered; 1 entry reversed. Filtered Date_Diff col to values > 0 to avoid them.
Created Prior to Today measure - TODAY()-4.
Attempted measure to return Transaction Date if it is <= 4 days from TODAY().
When Transaction Quantity added to PVT, number doesn't match qty for Transaction Date.
I feel like I'm close, but I can't work it out. Any assistance will be greatly appreciated. Thank you
