cancel
Showing results for 
Search instead for 
Did you mean: 

Actual vs Plan when plan is calculated by a formula

jorge_cepeda
Explorer
0 Kudos
198

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

Thanks

Accepted Solutions (0)

Answers (0)