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)
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.
Hi Amit,
This is parrt of my report as of now. So the table has different measures as KPIs and the segments as Dimensions. I want to subtract Advanced material segment for current month and advanced material for other period. You can see the formula I used, but since I used Where it gives same value in their respective adjacent columns.
I would suggest to break the formula first and see if values are populating or not for both.
=Gross revenue where Fiscal period="3" (check if you place this only then what is the value displaying).
=Gross revenue where Fiscal period="2" (check if you place this only then what is the value displaying.)
When I separate the formula, then it posts values on the respective columns. For example $5,238,000 beside Current Month( Fiscal = "3")
Also, I only need for Current Month (Fiscal Period = "3") and Other Period (Fiscal Period ="2"). Fiscal Period is also a dimension that I have added as a filter on the Segment column which is why it got separated into 2 columns based on Fiscal period values