Misc Costs totaling 3 times on invoice

I am attempted to show the total of the misc costs on an invoice.  I have created a calculated field for the misc costs that is equal to the extinvmisc only when the linetype is <> 1.  This does calculated correctly, but when I use a sum formula it is three times the correct amount.

Any Ideas?

Parents Reply
  • 0 in reply to Michael Ericksen

    Agreed - join is the likely culprit.  If you have comments (table OECOINO) in the join, the connection happening behind the scenes creates one record for each invoice line / comment combination.  So if you have 3 comments, you would have 3 records and Crystal is adding the value each time.  This is solvable with a formula, but much easier if you just use the data from the header table.  OEINVH.INVMISC should have the total of all misc charges.

Children
No Data