Calculated KeyFigure

[Former Member]

Hi there,

I want to calculate a key figure using a key figure and an attribute from a dimension .. pretty easy

well the problem is that defining the calculated key figure (query designer) I get listed only the key figure and no attributes (with numeric types) are listed there. why? and how can I do to have this attribute on the list...

Thanks in advance

FedeX

[former_member188975 · Accepted solution]

Hi Fedex,

To be able to get an attribute ket figure, you need to create a formula variable (from the formula builder window). Here specify replacement path as the processing type and select the char and the attr value that you need to pull into the query.

There is also a How To document with details on this method.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/72f4a790-0201-0010-5b89-a42...

Hope this helps...

[Former Member]

ThnX

FedeX

Message was edited by: FedeX

[Former Member]

Hi FedeX

give me your mail id, i will forward you a document for the same.

regards

vijaykumar

[Former Member]

Hi Fedex,

You must use Formula Variable, with Substitution with Attribute. You can create a formaula variable from: Right mouse click on KF tree in column --> New Formula --> New Formula Variable.

Ciao.

Riccardo.

[Former Member]

Hi dearie,

look here:

http://help.sap.com/saphelp_nw04/helpdata/en/ca/5f9ac61a205a459d0e7ef313d10321/frameset.htm

Hope it helps!

Bye,

Roberto