Running total for a group 1

[lwinstead]

Hello everyone,

I need help creating a "count" field that will count a number of records based on whether or not the field contains a valid number. In this case, a valid number is any number greater than zero.

The count field that I need will go in a group header, so a running total won't work. Specifically, I have an Invoice_Price field that either has a dollar figure or zero, and I need to get a count of all the non-zero values for this field.

So far I've tried to just get a count field going, but it picks up both zero and non-zero values, and the running total field I mentioned above, which can't display in the group header.

Can someone help me out? Thanks in advance...
<<<<[flux]>>>>

 

[synapsevampire]

Use a Formula containing something like:

if {Orders.Order Amount} > 0 then
1
else
0

Now you can do the right click->Sum on this and drag the sum into the group header.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[lwinstead]

SynapseVampire> YOU ROCK!

I don't know why I didn't think of that, myself. Probably because its actually rare that I write a totally new report.

Anyway, that was exactly what I needed. Thanks a lot. You're number one in my book.

(I'm so emphatic because I've been working on this particular &quot;problem&quot; for a couple days, off and on)
<<<<[flux]>>>>