Hi everybody,
I am currently working on a file where I have 2 periods (forecast period and actual period) divided in 4 quarters. In each of these quarters, I know the amount of customers, price per product and products per customers (in this case, the product is apple). With this information, I can calculate the revenues (customers * price per product * product per customer).
However, I want to see the revenue difference in both periods (actual compared to forecast) without calculating this every quarter. I have attached an example of my problem.
I have some difficulties with this, because I can not calculate the average of customers / rate / usage. I think this can be done with an array function, but I don't know how to use this.
Can you help me out please?
Thank you in advance!
Regards,
Gertjan
Bookmarks