Skip to Content
0
Former Member
Sep 20, 2005 at 11:10 AM

Multi-planning area and FOX

19 Views

Hello,

I have two planning areas <b>AREA1</b> and <b>AREA2</b>.

I have created a multi planning area <b>MAREA3</b> (which contains AREA1 and AREA2).

I created a planning function in MAREA3, under which is a FOX Formula.

The structures of AREA1 and AREA2 areas are mostly identical except for 1 field (call it <b>SUB</b>) which exists in AREA2.

In my FOX formula I copy the data from AREA1 to AREA2, and all values are copied OK except for <b>SUB</b>. When I view master data for SUB, I have the data I need to "build" the value from other fields in AREA1 (like a transcodification table).

My question, in the FOX formula, how do I use/read this master data table to get my value for SUB??

Thanks,

Tim