Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. I have a date field and an inventory field in my file and I would like to add the last and first inventory of the selected date range and divide it by 2 to get the average inventory. I've tried to do this with sets but with no luck at all. Any ideas?
Thanks
Hi,
Try
Avg({< Date = {'$(=Max(Date))', '$(=Min(Date))'} >} Inventory)
Hope that helps
One inventory value per date? Maybe this?
avg({<Date={'$(=max(Date))','$(=min(Date))'}>} Inventory)
Edit: Doh! Beaten to it.
Oh sorry my Bad, not actually there are more fields like articlenumber 🙂 I need the average inventory for all selected articles during a selected period.