Can a Category member be created to calculate Budget vs. Actual for $s and for as a percentage?

[former_member576285]

Hi BPC Community,

Note: For SAP BPC 7.5 Microsoft

Can a Category member be created to calculate Budget vs. Actual for $s and for as a percentage? I'm thinking that the two new category members will be calculations based on Budget and Actual. For Budget vs. Actuals in $s = BvA$ [formula: Budget-Actual]. And as a percentage BvA% [formula: ( | (B - A) | / ((B + A)/2) ) * 100].

I know that only alphanumerics can only be used in member names. I'll make up correct names later.

Thanks! Barry

[Former Member]

Hi Barry,

I agree with both Gavin that it could be done, and with John's question / recommendation , to do this in a report.  You could automate your comparison category with a property on your category dimension.  I would recommend doing the calculation in your report, vs. adding a calculated member to your category dimension.  Less overhead.

Cheers,

Brian

[JohnL]

Hi Barry,

I agree with Gavin but why can't you use a simple formula in your report?

thanks

[gavin_du]

hi Barry,

Sure you can. The percentage calculation you mentioned might be tricky, but you should be able to use IIF((B-A) >0, (B-A)/((B+A)/2), (A-B)/((B+A)/2)) instead.

Let me know if you have further questions.

Best Regards

Gavin

BPC Product Manager

[former_member576285]

Hi Gavin,

I plan on adding these two new categories. I've searched SAP and Google for some actual setup steps and some examples. Can't find anything relevant.

Can you point me to any technical links for examples?

Thanks. Barry