Per Invoice Per line formula?

[AlreadyLost]

Anyone know how I can make this into one line? Any formula?

Invoivce ID PE PE Amount ST Amount

IV35667 500 320.00 0.00

IW35667 600 0.00 123.00

I want to only show this as my result:

Invoivce ID PE PE Amount ST Amount (condition on PE = 600)

IV35667 500 320.00 123.00

 

[BobSuruncle]

With the small amount of data that you've shown us, I'd suggest this:
1.) Group on InvoiceID
2.) Suppress the GroupHeader and the Details sections
3.) Copy the InvoiceID field to the Group Footer
4.) Create a summary - Minimum of PE and place it in the Group Footer
5.) Create a Summary - Maximum of PE Amount and place it in the Group Footer
6.) Create a Summary - Maximum of ST Amount and place it in the Group Footer

Not sure if this is really what you want.

Bob Suruncle

 

[AlreadyLost]

The reason for the small amount of data is because I am working field by field. This report will bring back more invoices.. I just want to work with a small set of data first.

 

[synapsevampire]

This doesn't make sense, why would you not show both PE values, or the sum or some such?

If you want to limit data then use the Report->Edit Selection Formula->Record to limit the amount of rows being returned, which can be helpful during design.

Since "working field by field" probably means nothing to anyone else here as well, try posting technical information:

Crystal version
Database/connectivity used
Example data
Expected output

-k

 

[AlreadyLost]

I only want to display PE if the value is 500 and it's assoicated amount (PE Amount) and I would only display the other amount (ST Amount) if the PE is some other value besides 500. That is why I have a formula for ST Amount field (if PE =600 then Amount else 0.00).

Each "Amount" Field is base on certain PE.

 

[lbass]

Then you would conditional formulas like this:

//{@PE500amount}
if {table.PE} = 500 then {table.amt}

//{@PE<>500amt}:
if {table.PE} <> 500 then {table.amt}

Then right click on each and insert summaries at the group level, and then suppress the detail section.

-LB

 

[AlreadyLost]

Thanks everyone for helping. It works!!