Need to create Calculated Measures in SAC

[former_member338498]

Hi Team,

I am trying to create report, trying to replicate the calculations as of excel in SAC.

But unable to succeed. Please help or suggest work around.

Thanks in Anticipation

[JohnL · Accepted solution]

Hi Ashish,

You can create all these types of calculations in the modeler.

Qty		 Qty	
Price		 Price	
Unit		 Unit	
CumQty		 Cumulative Quantity			LOOKUP([Qty],[d/Date]= LastPeriods("Month",12))
PricePerUnit	 Price / Unit				[Price]/[Unit]
Amount		 Amount					[PricePerUnit]*[CumQty]
PriorAmount	 Prior Amount				LOOKUP([Amount],[d/Date]= Previous("Month",1))
DifferenceAmount Difference of Current - Prior Amount	[Amount]-[PriorAmount]
PriorCumQty	 Prior Cumulative Quantity		LOOKUP([CumQty],[d/Date]= Previous("Month",1))
ToBeCalc1	 ToBeCalc1				[PriorCumQty]*[PricePerUnit]
ToBeCalc2	 ToBeCalc2				[ToBeCalc1]-[PriorAmount]

[former_member377558]

Hi Ashish,

Could you please check the following page of our user's guide:
https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/e806754128de494ba47baf01f99d...

This section describes how to create Calculated Measures in SAC.

Best regards,
Adam

[former_member338498]

Hi Adam,

I missed to upload screen shot in my question upfront.

please find the updated question.

regards,

Ashish

.