Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Changing the formula to a key figure on a query

Hello All,

I do not have access to BEx. I would please like to know how to change the formula to a key figure "Total $" in a QD Promo Analysis query (technical name - N03_Q_D_N03_SD_502_0003). Will transaction RSRT take me to the query and eventually the formula so I can change it? If so please give me guidance as this is the first time I go into transaction RSRT. If there is another way please also give guidance.

Thank you and kind regards

Keith Kibuuka

Former Member
Former Member replied

hi Keith,

i think you will find the formula in 'column' area following 'keyfigure', you can right click it and 'edit'.

then specify the calculation you want.

if it's calculated keyfigure actually then there will be warning that changes will impact to all queries from the same infoprovider, it's 'global'. recommended is create a new formula, right click keyfigures and 'new formula'.

take a look

http://help.sap.com/saphelp_nw2004s/helpdata/en/71/0aec3b6e011341e10000000a114084/frameset.htm

hope this helps.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question