Skip to Content
avatar image
Former Member

Need to exclude 2 location from macro while calculating independent Req

Hi All,

I have a scenario and need help in finding solution.

Have 1 product belong to 4 location A,B,C and Z

Lane is from Z to A

Lane is from Z to B

Lane is from Z to C.

So distribution demand comes from A,B, C to Z.

while calculating independent Req I want to consider Dis. Dmd coming from C but don't want to consider Dis. DMD coming from A and B.

Please suggest me possible solution.

One possible solution which i can think of is to exclude Location A and B from Macro while calculating independent Re, but don't know much about macro.

Please Help me with possible solution , or how to exclude it using macro.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 10, 2016 at 12:35 AM

    I know this a bit of a late reply. But still answering this so that it might benefit someone!

    You could use the function ACT_LOCATION( ) to exclude  the location.

    For example, you want to exclude Location XYZ from the calculation, you could use the function like below:

    Step: Calculate Independent Requirement

    IF

    Location = XYZ

        ACT_LOCATION( )

        = 'XYZ'

    Row: Independent Requirement =

        SUM(

        Row: Forecast

    ELSE

    Row: Independent Requirement =

        SUM(

        Row: Forecast

        Row: Distribution Demand

        )

    ENDIF

    Hope this helps.

    Cheers

    Sam

    Add comment
    10|10000 characters needed characters exceeded