Hi,
Is it possible to reference the value of a calculation in another cell in a table/pivot (like done in Excel)?
I am developing a forecast and order plan app and its having some pretty advanced calculations. For example for each of the 12 coming months i calculate:
- Expected number of items in Stock (based on opening balance and average usage)
- I will then have to calculate when to order more products based on expected delivery time etc. This will then loop back to the expected balance once the products have come in to stock.
I do want to avoid to complex formulas and have more straight forward excel formulas as I expect them to be easier maintaining and debugging.
-
