Skip to Content

Need to create Calculated Measures in SAC

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

sac-question.png (34.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 30 at 06:28 PM

    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]
    
    
    
    Add comment
    10|10000 characters needed characters exceeded

  • Feb 21 at 08:30 AM

    Hi Ashish,

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

    This section describes how to create Calculated Measures in SAC.

    Best regards,
    Adam

    Add comment
    10|10000 characters needed characters exceeded