How to accumulate on rows

[Former Member]

All,

In data:

<line>1</line><time>7:00</time><pass>50</pass>

<line>1</line><time>8:00</time><pass>75</pass>

<line>1</line><time>9:00</time><pass>45</pass>

<line>1</line><time>10:00</time><pass>60</pass>

Desired output:

<line>1</line><time>7:00</time><pass>50</pass><pass.a>50</pass.a>

<line>1</line><time>8:00</time><pass>75</pass><pass.a>125</pass.a>

<line>1</line><time>9:00</time><pass>45</pass><pass.a>170</pass.a>

<line>1</line><time>10:00</time><pass>60</pass><pass.a>230</pass.a>

So we have a cumulative total.

We tried Totalizer, but the accumulate there doesn't make sense. Cross tab didn't give us per row, only on break totals.

[agentry_src]

Hi Paul,

Use a repeater with an assignment block that adds the current line-time value to a local property and then assigns it to your output xml or to an MII Output document. That is the simple method. You could also do some XPath calculations, but this works and is easy to implement.

Good luck,

Mike