×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• 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.

# Formula for suppressing rows

## Formula for suppressing rows

(OP)
If two rows of data has duplicate data with the exception of the {extended amount} but the two rows with extended amount sum to zero.
How do I suppress both rows? I do not want any grouping.
i.e.
row 1 field {customer no}, field [
{item code}, field [invoice no},field {extended amount} = +5.00
row 2 field {customer no}, field [invoice no},field {item code},field {extended amount} = -5.00

### RE: Formula for suppressing rows

The real question here is why is the row duplicated? The answer is likely due to the way you have your tables linked. Please provide a list of tables and how they are linked.

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

### RE: Formula for suppressing rows

(OP)
Lines are duplicated where invoice numbers may be the same due to fact that I am retrieving every line item on each invoice. There is no problem with my linking.

### RE: Formula for suppressing rows

First create a formula {@all} that includes all fields except the ext amt field, like this (use ampersands so you don't have to convert fields to the same datatype):

//{@all}:
{Table.custno}&{table.item}&{table.invno}

Then use a suppression formula like this on the detail section:

(
not onlastrecord and
{@all}=next({@all} and
{table.extamt}+next({table.extamt})=0
)
Or
(
Not onfirstrecord and
{@all}=previous({@all}) and
{table.extamt}+previous({table.extamt})=0
)

You should also format the detail section to "suppress blank section."

-LB

#### 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.

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:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!