I am currently working on developing a forecast accuracy report for the business that I work for. This is driven off of data within our IFS Applications ERP software. We are capturing snapshots of the forecast on a daily basis. Based on the delivery date to our customer/s I have built the logic in the script editor to return data from the correct days snapshot.
However when I come to visualize this in a table in the final app it is throwing out some spurious numbers.
Below is the logic from the script editor to pick the correct days snapshot based on the delivery date:
Our Sales data is detailed at the following levels: Customer, Product, Delivery Date, Shipping Address whilst Forecast is Customer, Product and Delivery Date. Therefore where I am pulling in a Forecast value I am actually pulling the same value multiple times (to each record = shipping address).