A New Home in the New Year for SAP Community!

Exciting times ahead for the SAP Community! We've outgrown our home, so we'll be migrating to a new platform later this year. Let's continue the journey together!

Nov 13, 2008 at 08:04 PM
# NEED ADVICE about Inserting a custom formula column in EXPANSION memberset

Dear all:

I am asked to create a report with TIME(col), ACCOUNT(col), PRODUCT(row), where ACCOUNT stores Beginning Inventory Amt, COS, etc.

The problem I am having is that the user requests to have a place to show COS ratio column. COS ratio value is derived from ACCOUNT **COS** and ACCOUNT **NETSALES** of my ACCOUNT MEMBERSET.

I tried various ways but was unable to keep the formula in EVDRE so this COS ratio column's formula goes with the rest of the expansion.

The result I want is something like below, where NETSALES and COS are my dimension members and RATIO is Excel formula STDCOST/COS... As the report expands by different TIME hierachy (i.e. 2008.total, 2008.h2, 2008.q3), RATIO is expanded accordingly.

Is this doable in EVDRE?

2008.10 2008.11 2008.12

NETSALES COS RATIO NETSALES COS RATIO NETSALES COS RATIO

PRODUCT1

PRODUCT2

PRODUCT3