Skip to Content
0
Aug 15, 2017 at 08:20 PM

Variance Calculation

270 Views

Hi Friends

Env BPC 10.1

I have a question related to the best practices of calculating variances in BPC reports.

Variances could be Actual-Plan, Actual - PY Actual, Actual - Working forecast, Plan-workingforecast to name a few.

Currently these are simple excel calculations in a BPC reports as local members.

Users want to store these and some other variances(Performance Variance which takes into consideration FX changes) in the BPC database, so that they can be easily pulled into a report.

Is it a best practice to store these variances in BPC.

Thanks for your time

Ed