Skip to Content
Sep 08, 2018 at 09:16 PM

Actual vs Plan when plan is calculated by a formula


In a very basic planning model, for Planned revenue I calculate REVENUE as PRICE x QUANTITY

When I load data for Actual REVENUE from a file, I got the mesage: You can not load data in a calculated member.

I also tried creating a CALC_REVENUE to beused in Plan and then move it to Account REVENUE using Data Actions and/or Scripts, to copy data from CALC_REVENUE

IN summary: How do compare Actual vs Plan when the account is calculated in PLAN and Actual is a number that comes from the accounting system