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 unit
Thanks for the help
Regards,
Firdaus
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |