Running Total formula 1

[acessn]

Hi.

Using CR 9.0

I have a Running Total (sum) that evaluates on change of "group #2 @Employee Name an Number". This works fine, but what I need to do is to somehow get this into "Use a formula."

This is because I need to exclude some records. In the formula I will say

not(VP_EMPLOYEE.PAYRULENAME="Hours")

, but I also need to evaluate on change of group #2.

Any ideas?

Thanks,
Bjorn

 

[Madawc]

Try {your.field} <> Previous({your.field})

Madawc Williams (East Anglia, UK)

 

[acessn]

Hi.

It didn't count the first record with this formula, but worked like a charm when I used

{your.field} <> Next({your.field})

Thanks for the tip!

-Bjorn

 

[lbass]

You might have a problem with the last record using this formula. You could use:

onfirstrecord or
{table.field} <> previous({table.field})

-LB

 

[acessn]

Thanks a lot LB.

I didn't see that one coming..

Regards,
Bjorn