Unable to summarize results without inflated values or duplicated detail rows

Create a new formula field like so:

If {Line} = 1 Then {Total Amount} Else 0

Summing this one up will give the required result. (Assumption here is that every invoice has exactly one line number 1.)

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top