Keyfigure in Percentage

[Former Member]

Act_Sales_2008 Target_sales_2008 Act_sales_2009 Target_sales_2009 Overall_result overall_result %Target

(actual) (Target)

-

---

200 300 400 500 600 800 --

100 600 500 100 600 700 ---

Hi,In my requriment ,I have like this

I am able to get all these keyfigures except the % target.

Please guide me

Regards

Naresh

[former_member189638]

Create a Formula Key Figures and not Calculated Key Figure. Use the Percentage and Data Functions while creating the Formula

FKF1: SUMGT 'Act_Sales_2008' %A SUMGT 'Target_sales_2008'

FKF2: SUMGT 'Act_sales_2009' %A SUMGT 'Target_sales_2009'

[Former Member]

Hi,

Instead of using overall Result.

Create two CKF's

Actual(Overall) = Act_Sales_2008+Act_sales_2009

Target(Overall) = Target_sales_2008+Target_sales_2009

Then create another CKF

overall_result %Target = Actual(Overall) %A Target(Overall)

This will give you the expected result.

-Vikram

[Former Member]

Sorry ,I had not wrritten the formula.

FOr %Target = Overall_Actual Sales / Overalltarget_sales

And the values should be displayed in Percentage.

I cannot create Calculated keyfigures for overall actual salesa andoverall_ target sales.Because It should display this structure for each period.

Regards

Naresh

[Former Member]

Hello,

Please, could you elaborate what is the formulae written in OVER_ALL% TARGET. its not diplaying the value or % symbol.

If you would like to display the % symbol for the OVER_ALL% TARGET then you need to -> go to

local calculation -> calculate single values as = Normalization according to the Over Results need to be set . If this option is set, it will display % symbol

Thanks

Edited by: Geeta Sharma on May 24, 2010 3:03 PM