I am working on a load script and ran into an issue with loading data based on the first and last day of every month in a table. I have attached a copy of the table I am working with "Small Subset of data" . As you will see there is an on hand quantity for each day of a month. I need to pull the current On Hand Qty for the last day of every month so I know what the current on hand qty is for an item.
The app has two table boxes one that allows me to select a year and show me totals based on certain criteria for that year. The other table box breaks it out based on month.
I have been pulling my hair out over this one and I am sure it is something simple I am overlooking.