I have created an aggregated form with a monthly period in order to record information on the stock level of a medication. The form includes a field which displays the stock level of the products at the start of the month, which should match the stock level at the end of the previous month.
I would like this field to be automatically populated with the quantity of medication from the end of the previous month. To do this, I have created an indicator using the formula:
However, when testing the monthly stock level form, the indicator is not displaying any information and remains empty. I am unable to determine the cause of this problem. Can anyone help me resolve this issue?