Changing the formula to a key figure on a query
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
Edwin Harpino replied
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
hope this helps.