Skip to Content
0
Former Member
Dec 09, 2008 at 05:22 PM

Multiply Running Total Field

333 Views

I'm using a running total field to count records for a subgroup. It does a distinct count on a field "for each record" and resets "on change of group". This works great. I'd like to take this value and multiply it by another normal (non running total) database field. So if the running total is field is "5" and the database field is "10" the result would be "50".

What is the best way to do this?