Hi Inmedia,

So you should loop though some children, and then show the data on the page above those children.

Then something like the razor blow should work for you.

@{ var selection = CurrentPage.Children.Where("Visible"); }

@if (selection.Any())
{
    <ul>
        @foreach (var item in selection)
        {
            <li>
                <a href="@item.Url">@item.Name</a>
            </li>
        }
    </ul>
}

What you need to do is to call custom properties is:

@item.PropertyAlias

Inside the foreach loop

Hope this helps, and let me know if I have misunderstood your question.

/Dennis

Hi Dennis

I think I wasn't precise enough in my post.... What I need is for razor to calculate the sum of a numeric property that all children has.

I have a table that list all the children and their values. Each child gets a row... This I have already set up using the method you posted.

But in the bottom of this table, I need a sum function that calculates the total of all the child values.

Hope this makes sense? :)

I have made an image to visualise what I need :)

Hi Inmeida,

How far have you got? Have you managed to render out the table without the sum?

If so, can you share your razor code so we can get a feel for what you are doing?

Thanks,

Nik

Hee Inmedia,

I think you can try something like this:

@Model.Childeren.Where("Visible").Sum(p => p.antalVisnigner);

Cheers,

Hi Inmedia,

Rick's option is one possible route, however it does mean querying your fields multiple times. This shouldn't be a problem but this is an alternative:

@inherits umbraco.MacroEngines.DynamicNodeContext
@* Ensure that the Current Page has children, where the property     umbracoNaviHide is not True *@
@if (Model.Children.Where("Visible").Any())
{
    int sum = 0;
<tbody>            
    @* For each child page under the root node, where the property umbracoNaviHide is not True *@
    @foreach (var childPage in Model.Children.Where("Visible"))
    {
        <tr>
            <td>@childPage.Name</td>
            <td>
                @* Format numeric value with punctuation *@
                @if (childPage.HasValue("antalVisnigner")){ 
                    int price = childPage.antalVisnigner;
                    string formattedPrice = price.ToString("#,##0");
                    sum  =+ price;
                    @formattedPrice     
                }
            </td>
            <td>@childPage.antalKlik</td>
            <td>@childPage.cTR%</td>
            <td>@childPage.avgCPM</td>
            <td>@childPage.cost</td>
        </tr>
    }
</tbody>

<tfoot>  
    <tr>
        <th>Total</th>
        <th>Sum: @sum  </th>    @* <-----  This is what I can't figure out *@
        <th> </th>
        <th> </th>
        <th> </th>
        <th> </th>
    </tr>

</tfoot>
}

int summed = Model.Children().Sum(x => x.GetPropertyValue<int>("antalVisnigner"));

is working on a reply...