Skip to Content
0
May 31 at 12:09 PM

Formula to add two Dimension values

144 Views

Hi Team,

I want to create a Formula for GROSS PROFIT = SALES REVENUE – COGS – MFG.EXP. All these are the values in COMPONENT Dimension.

COMPONENT Dimension has the values as below:

SALES REVENUE

COGS

MFG EXP

MARKETING EST

DELIVERY CHARGES.

The Gross Profit should be calculated based on Sales Revenue, COGS and MFG EXP

Iam using the Hierarchy as below. How to calculate the formula?

As of now iam doing calculation in Excel and loading which i dont want to