I'm asking you a question because I need help.
Initially, inventory calculation was implemented using formulas on the table.
When there aren't many rows, I'm happy that it's calculated very quickly.
However, after saving 10,000 rows for testing, the speed became very slow when calculating.
So I'm going to delete the table formula after reading Dan's post and proceed with the calculation on the app screen.
I want to know if it's right to make it in automation.
And please review the formula I made.
What I want is to remove it from 'From Location' and add it to 'To Location'.
In order to distinguish the presence or absence of existing inventory, we created Run Option with 'Count'.
When we don't have inventory, we just need to put transfer data on it.
It's hard to calculate when we have inventory.