Morning!
We are trying to create a restocking report so that our store employees can restock the floor as items sell.
Below are 2 versions of the copy of our formula and the report in analyzer.
1st version below
- utilizes the filters option and I placed the beast mode into filters and apply a >1 to reflect Qty Sold >0 units.
*This was created on Nov 10th and worked until Nov 15th; so I'm curious why it stopped working as well.
2nd version below
- I removed the beast mode in filters and rewrote the formula to include the greater than statement. It was validated, however the results show zero in the Qty Sold column again.
I appreciate advice and tips on any nuances of Beast Modes, when it's best practice to use them as filters, best practice to write more in a formula, etc.
Thank you for your time and efforts with this project.
Happy Thanksgiving!