I have got an Excel file with the following columns: Product, date and amount.
The calculation is for each date, the sum of a range of days backwards (30, 60…., 365) divided the amount of days that product had stock movement (in and out), this is not precisely 30, 60…, 365 since within that
range there can be days in which such product didn't have any stock movement. I send you an attached Excel file as sample. I would really appreciate you helping me.
Looking forward to hearing from you.
Regards
Sandro.