Suppressed values in Running Totals

[Monkey820]

Hi There!
I am trying to get accurate totals.
I have a "production hour" field that I need to know the "operator requirement" value for.
If the production hour value is "0", then I have it supressed, but if there is a value in the "operator requirement" field, it is still showing up in my total and I don't want it to if the production hours are 0.
Can someone help me by telling me how to not include values in my total from a supressed detail item or how I would do it otherwise?
TIA
Micky

 

[IdoMillet]

Create a formula that returns the value for cases where it should be inceremented and 0 for all other cases.

Then, simply sum that formula.

A similar approach can be applied for Running Totals.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Monkey820]

I am sorry....
I do not know how I would do that.
Can you explain in further detail?
TIA
Micky

 

[lbass]

If you are using running totals, then select the field you want to summarize, choose the summary, evaluate based on a formula:

{table.productionhours} <> 0

Reset never or on change of group, depending upon your needs. This assumes your only suppression criterion is {table.productionhours} = 0.

If you do not otherwise need running totals, then you could create a formula:

if {table.productionhours} <> 0 then {table.value}

...and then insert a summary on this formula.

-LB