Forum Discussion
Calculating stock pendancy
Hi everyone! Hi need help with a formula to calculate the amount of days a product was in stock. So i use a formula to calculate the stock so i know in a line chart how much there was based ...
Anonymous i dont think it is the correct measure. i have two tables, calendario and reclamacoes. the first one has all the dates until today and a calculated column to calculate the stock based on table reclamacoes. on the other table i have an id, date of creation and date of encerramento. this means that if a reclamacao had the data encerramento after a certain date, it was on stock on wvery dates until the encerramento.
What i want to calculate is the average time a reclamacao is on stock for every date in the calendar.
table reclamacoes
table calendario
thanks so much in advance!