# ForEach

When we have multiple nodes and want to execute the same operation for each of the node, we will use the ForEach function. It is not applicable for performing operation to a single node.

### Syntax

ForEach (Array,Iterator)

### Arguments

<table><thead><tr><th width="144">Arguments</th><th width="166">Datatype</th><th>Description</th></tr></thead><tbody><tr><td>Array</td><td>Node Name</td><td>The node for which the iterator statement is executed for all the periods.</td></tr><tr><td>Iterator</td><td>This, Children, Parent</td><td>The operation that is to be executed.</td></tr></tbody></table>

### Example

Consider the below scenario where we have Revenue and cost items for different regions. Our objective is to calculate the total costs incurred for marketing.

<table><thead><tr><th width="237">Year</th><th width="121" align="right">2020</th></tr></thead><tbody><tr><td><mark style="color:orange;"><strong>US Marketing (FOREACH)</strong></mark></td><td align="right"><strong>14000</strong></td></tr><tr><td>    <mark style="color:purple;"><strong>New York (Sum children)</strong></mark></td><td align="right"><strong>2510</strong></td></tr><tr><td>       <mark style="color:green;">Men (Subtract Children)</mark></td><td align="right">1000</td></tr><tr><td>          <mark style="color:yellow;">Revenue (Sum Children)</mark></td><td align="right">4500</td></tr><tr><td>               Sales </td><td align="right">4000</td></tr><tr><td>               Receivables</td><td align="right">500</td></tr><tr><td>          <mark style="color:red;">Costs (Sum Children)</mark></td><td align="right">3500</td></tr><tr><td>               <mark style="background-color:green;">Marketing</mark></td><td align="right"><mark style="background-color:green;">3000</mark></td></tr><tr><td>                Salary</td><td align="right">500</td></tr><tr><td> </td><td align="right"> </td></tr><tr><td>       <mark style="color:green;">Women (Subtract Children)</mark></td><td align="right">1510</td></tr><tr><td>           <mark style="color:yellow;">Revenue (Sum Children)</mark></td><td align="right">5510</td></tr><tr><td>                 Sales </td><td align="right">5000</td></tr><tr><td>                 Receivables</td><td align="right">510</td></tr><tr><td>            <mark style="color:red;">Costs (Sum Children)</mark></td><td align="right">4000</td></tr><tr><td>                  <mark style="background-color:green;">Marketing</mark></td><td align="right"><mark style="background-color:green;">2000</mark></td></tr><tr><td>                   Salary</td><td align="right">2000</td></tr><tr><td> </td><td align="right"> </td></tr><tr><td>    <mark style="color:purple;"><strong>LA (Sum children)</strong></mark></td><td align="right"><strong>-4120</strong></td></tr><tr><td>    <mark style="color:green;">Men (Subtract Children)</mark></td><td align="right">-1200</td></tr><tr><td>            <mark style="color:yellow;">Revenue (Sum Children)</mark></td><td align="right">4000</td></tr><tr><td>                   Sales </td><td align="right">3500</td></tr><tr><td>                   Receivables</td><td align="right">500</td></tr><tr><td>             <mark style="color:red;">Costs (Sum Children)</mark></td><td align="right">5200</td></tr><tr><td>                    <mark style="background-color:green;">Marketing</mark></td><td align="right"><mark style="background-color:green;">4000</mark></td></tr><tr><td>                    Salary</td><td align="right">1200</td></tr><tr><td> </td><td align="right"> </td></tr><tr><td>       <mark style="color:green;">Women (Subtract Children)</mark></td><td align="right">-2920</td></tr><tr><td>             <mark style="color:yellow;">Revenue (Sum Children)</mark></td><td align="right">4080</td></tr><tr><td>                     Sales </td><td align="right">3540</td></tr><tr><td>                     Receivables</td><td align="right">540</td></tr><tr><td>                <mark style="color:red;">Costs (Sum Children)</mark></td><td align="right">7000</td></tr><tr><td>                     <mark style="background-color:green;">Marketing</mark></td><td align="right"><mark style="background-color:green;">5000</mark></td></tr><tr><td>                     Salary</td><td align="right">2000</td></tr></tbody></table>

To achieve this, the following formula should be written in the <mark style="color:orange;">\[US Marketing]</mark> node,

<mark style="color:blue;">**`SUM`**</mark>**`(`**<mark style="color:blue;">**`FOREACH`**</mark>**`(`**<mark style="color:blue;">**`THIS`**</mark>**`.`**<mark style="color:blue;">**`CHILDREN`**</mark>**`,`**<mark style="color:blue;">**`FOREACH`**</mark>**`(`**<mark style="color:blue;">**`THIS`**</mark>**`.`**<mark style="color:blue;">**`CHILDREN`**</mark>**`.`**<mark style="color:blue;">**`THIS`**</mark>**`,`**<mark style="color:blue;">**`THIS`**</mark>**`.`**<mark style="color:blue;">**`CHILDREN`**</mark>**`.`**<mark style="color:blue;">**`GET`**</mark>**`(2).`**<mark style="color:blue;">**`CHILDREN`**</mark>**`.`**<mark style="color:blue;">**`GET`**</mark>**`(1))))`**

### **Explanation**

<table><thead><tr><th width="267"></th><th></th></tr></thead><tbody><tr><td>(FOREACH (THIS.CHILDREN,</td><td>As we are entering the formula in the parent node of both regions - New York and LA , THIS.CHILDREN will refer to each of the children of <mark style="color:orange;">[US Marketing]</mark> node which is <mark style="color:purple;">[New York]</mark> and <mark style="color:purple;">[LA]</mark></td></tr><tr><td>FOREACH (THIS.CHILDREN.</td><td>This will refer to each of the child nodes of <mark style="color:purple;">[New York]</mark> and <mark style="color:purple;">[LA]</mark> which are <mark style="color:green;">[Men]</mark> and <mark style="color:green;">[Women]</mark></td></tr><tr><td>THIS,</td><td>This refers to that same node so it will be <mark style="color:green;">[Men]</mark> and <mark style="color:green;">[Women]</mark> </td></tr><tr><td>THIS.CHILDREN.GET(2).</td><td>This will consider the second child <mark style="color:red;">[Costs]</mark> of the Men and Women nodes as we have mentioned Get(2)</td></tr><tr><td>CHILDREN.GET(1) )))</td><td>This will get the value of the first child of <mark style="color:red;">[Costs]</mark> that is <mark style="background-color:green;">[Marketing]</mark>. Sum of these <mark style="background-color:green;">[Marketing]</mark>nodes are returned which is 14000.</td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.valq.com/model/formula-functions/range-functions/foreach.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.