Skip to Content
Former Member
Dec 11, 2006 at 10:54 PM

FOX - foreach loop in multi-area


Hello All,

When using a foreach loop in a multi planning area, the loop goes through the data in all of the planning areas. Is there a way to limit the loop to a specific planning area? I know that using an IF...ENDIF statement you can evaluate the planning area, but this is done after the data has already been selected.

For example, suppose I have planning areas 1 and 2 in a multi-area and area 2 has a percentage value that I want to retrieve and use for a calculation. So when I loop through data, I don't want to evaluate data in area 1 at all, only in area 2. The end result is to post data in area 1, which is why I must use a multi-area.