09-05-2022 04:34 AM - last edited on 05-02-2023 10:25 AM by JackLacava
Hi All,
I'm hoping someone can help. I'm trying to create a formula for a planning solution that calculates an average over a dynamic number of time periods but for hundreds of intersections. So essentially I somehow need a data buffer covering multiple time periods that I can then use in my over arching planning formula.
The main thought was to loop through the time periods, which is fine, but I can't use an api.data.getdatacell because of the volume of intersections I want to calculate the average for. Is it possible to build up a data buffer in a loop?
If only i could create a V#TrailingXmonthavg formula where I can replace the X with a dynamic value.
Any thoughts would be greatly appreciated.
Many thanks in advance.