×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

CR8 Conditional formula for detailed records

CR8 Conditional formula for detailed records

CR8 Conditional formula for detailed records

(OP)
Hi:

I have a conditional formula to add particular fields together excluding 0 amounts. The problem... all records print regardless of what the formula's are requesting it to do.

Any help appreciated.

James

RE: CR8 Conditional formula for detailed records

Hi James,
Hmm - you are adding fields together, but only if the fields are not equal to zero.  I presume you are doing this to optimize the report performance, so that you don't add zeros unnecessarily.  However, the extra time it takes to check to see if a value is zero probably more than offsets any gain, so you are probably better off just adding up all amounts, including the zeros.
If you want to suppress the fields with zeros from printing, you can either do that for the individual field(s)as a format option, or for the entire section that the field(s) is/are in.
I'm not entirely convinced I understand the problem, so please clarify if this is so...

Malcolm Wynden
I'm for sale at http://wynden.net
malcolm@wynden.net

RE: CR8 Conditional formula for detailed records

(OP)
Hi Malcolm:

I greatly appreciate your response.

I have a formula {Total Billed YTD} that adds 2 data fields together. This formula is in the detail section of the report.  There are many records in the detail that will have 0.00 in these 2 fields.  I need to prevent these records from printing because I also have a formula that calculates profit percent and of course I get the "Division by Zero" error.

I tried formatting the Total Billed YTD to Supress Zero but this doesn't work because the formula still tries to calculate the Zero Detail Lines.

Thank You so much for your expertise.

James

RE: CR8 Conditional formula for detailed records

Probably the easiest way is to exclude the zero amounts from the percentage calculation
//ProfitPercent formula
If {@Total Billed YTD} = 0 then
   0
Else
  your existing profit percent formula text

Malcolm Wynden
I'm for sale at http://wynden.net
malcolm@wynden.net

RE: CR8 Conditional formula for detailed records

(OP)
Greetings Malcom,

Thank you so much for the tip on modifying the Percentage Formula, this worked great.

You have my vote for #1 Tech!

James

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close