Sum stock by range date

Dear AppSheet Team,

 

I have problem for total sum, I want to calculate the total material that must be returned if the maximum limit is 3 days after collection. 

For example, I have the outbound table, with the following conditions:
- there are 2 materials with a request date of 13 September and must be returned on 16 September
- What must be returned are those in the stock column with a minimum qty of 1 unit
but why is there material with the date 30 August still being read, so that in the virtual column stock available the total is 2 units instead of just 1 unitoutbound table.jpgvc formula.jpgreturn.jpg

Thanks for the help

Regards,

Firdaus

 

0 4 176
4 REPLIES 4
Top Labels in this Space