Need to summarize field, but exclude suppressed values

[j7b]

Howdy,

I'm a fairly new CR user so bare with me.

I have a report that looks at customer A/R history by line item. (shows invoice/check number, and balance at current 30 60 90+).

If the customer has a credit in one of the aging columns it shows as a negative number (as expected). For this particular report I do not wish to include the credits in the aging columns.

So what I did was use the &quot;suppress&quot; check box on each field (30, 60, 90) and used a formula something like &quot;IF aged30days <= 0 THEN TRUE&quot;

This worked great, the credits do not show up.

But now when I try to summarize each column, the summary includes the negative numbers in the formula.

Is there a way to tell the summary to only total the fields the values that are displaying?

TIA

J7B

 

[synapsevampire]

Rather than use field level suppression, exclude them from the data returned by using the record selection formula:

Report->Edit Selection Formula->Record

Place something like:

{table.field} >= 0

-k

 

[j7b]

Thanks for the speedy reply K. I should go into more detail.

The report shows each open line item, and it's balance. The balance could fall in current, 30, 60, or 90+.

However, any open credits should fall into a column of their own. So what I did was suppress values less or equal to zero in the cur, 30, 60, 90+ columns, and added a 5th column &quot;total open credit&quot;, used a balance field that I have access to (basically the balance of the line item regardless of it's againg period) and supressed values greater than or equal to zero.

So, I still need to print the line items that are negatives, so I can't exclude them totally.

Does that make sense?

I'm thinking I might have to use a formula that says add all positive balances, and plug that in as my summary, but I'm not sure how to state that.

Thanks again for your suggestion!

 

[putts]

Try doing an Insert/Running Total Field.
Select the field you're wanting to summarize ({aged30days}).
Under Evaluate, select the formula option and in your formula, enter the formula that leads to the field not being suppressed.

In other words, if {aged30days} should only be counted when it's greater than 0, put {aged30days} > 0 in the formula for the Running Total.

 

[j7b]

Ata you Putts! That worked perfectly. Thanks a lot!