AnsweredAssumed Answered

Script help??

Question asked by DavidGunter on Jun 6, 2018
Latest reply on Jun 7, 2018 by justinc

My script wants to calculate the count of plants available for harvest on today’s date. There were two planting dates; the harvest date is known by adding the amount of grow days to the planting date.  

 

In this example, the found set groups the two planting dates. There are two records, each containing 50 plants, one ready for harvest, one not.

 

I need some help with the next script step(s) to arrive at the intended result, which is an opening inventory number of plants ready for harvest, dependent on the current date.  

 

Many Thanks!!

Screen Shot 2018-06-06 at 2.30.20 PM.png

Outcomes