Calculation to use Attribute and key figure

[chris_robertson]

We'd like to create a query with a calculated key figure that uses an attribute & a key figure. On 0Material we have cost as an attribute. We'd like to write a formula that uses this cost along with the net sales in the cube. Any ideas on how we would do this?

Thanks,

Chris

[Former Member · Accepted solution]

Hello Chris,

Please go through this document. It discusses how to use attribute in calculation.

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

Hope it helps.

Regards,

Praveen

[chris_robertson · Accepted solution]

Thanks! Great documentation.

[Former Member]

Chris,

You could do this using formula variables

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

Refer

http://help.sap.com/saphelp_nw04/helpdata/en/03/6ba03cc24efd1de10000000a114084/frameset.htm

-Doodle