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.

10|10000 characters needed characters exceeded

• 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