Hi, I made an inventory control app, but now I need to calculate the amount of outputs every month. I can’t find the formula for this. Can someone help me?
I researched all these formulas but I can’t understand how to use them correctly
You’ll have to provide more details, or ask more specific questions.
1 Like
in the first photo we see the outputs page, it shows all the outputs made so far, and below we see the current stock of the item. I would like there to be a field that returns the total outputs for the current month.
You’ll probably need to write an expression that checks to see if an output record matches the current month, and then count all of the outputs.
You can try using a MONTH() function like MONTH(TODAY()) to compare the date column of the output record
After that, it should just be a combination of COUNT() and SELECT() to make sure the correct output records are counted.
2 Likes
Darmund:
coluna de data do registro de saída
how do I connect the MONTH (TODAY()) expression to the checkout date column
Perhaps
MONTH( [Checkout Date] ) = MONTH( TODAY() )
in the condition of your SELECT.
1 Like