Skip to Content
avatar image
Former Member

Subtraction of values from 2 columns in a row in Web Intelligence

Hi,

I am very new to WebI and SAP in general. I have to subtract 2 Gross Revenue values of 2 fiscal period to calculate the percentage difference. Can you guide me a way to do it.

Sample Data Table: Segments SegA ( Fiscal period=1) SegA(Fiscal Period=2) Gross Rev $5800 $5400

I want another column Difference% with the subtracted value of 7.4% (i.e 400/5400)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 13 at 03:13 PM

    i am assuming you have two objects one for fiscal period 1 and period 2.

    try this.

    =([Fiscal Period1]-[Fiscal Period2])/[Fiscal Period2]

    if above formula will not work then create dummy format in excel with available objects and attach the screenshot here.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member AMIT KUMAR

      When I separate the formula, then it posts values on the respective columns. For example $5,238,000 beside Current Month( Fiscal = "3")