Conceptual Question: Data Replacement and Calculated Columns

Overarching issues:
   • Need a way to drop in new data/replace info in ‘Actuals’, ‘FCST’, and ‘FAOP’ each month without previously entered calculated columns [Actual Sums] and [B/(W)] in ‘FAOP’ being deleted. NP: If you want to keep "previously entered calculated columns", you will need to keep the previous data that populated those calculated columns. Perhaps you need some sort of versioning / snapshot for the "FAOP".
   • New COAs (data identifiers) can be created daily and do not always line up between ‘FAOP’ and ‘Actuals’, need a way to provide for that NP: If there is no match between FAOP and Actuals, what is the desired behavior?
Specific issues:
   • Calculated [B/(W)] column is not pulling in all COAs. Most likely due to some COAs appearing on ‘FAOP’ that don’t appear on ‘Actuals’, and some COAs appearing on ‘Actuals’ that don’t appear on ‘FOAP’. NP: If there is no match between FAOP and Actuals, what is the desired behavior?

Cheers,

Nathan