Sum LineItems for Invoice total

[LindaG]

I swear this has worked for me in the past but for some reason it won't work. I don't know what I have wrong ...

Invoices joined to LineItems on Invoice# which is text similar to 0777736.

Field in LineItems called NetTransAmount (number) which looks like:

26.47

-3.28

44.80

-58.27

I created a calculation (number) in Invoices with:

Sum(LineItems::NetTransAmount)

These lineitems are a merge of several dbs from an old DOS program. But my totals calculate all lineitems for each invoice except for the last one!:

I created a new regular number field and set NewNumberField with NetTransAmount and sum'd that field - still nada. Won't grab the last payment (-68.00) or whatever.

The Invoice# is exact. I use Go To Related (show) and view the associated lineitems. The invoice # is the same, the formatting (when viewing leave format as entered) is the same but still won't total right.

It's probably something silly right in front of my face but I can't see it. Any suggestions? Oh, I also created a selfjoin within lineitems on the invoice number. A SUM(SelfJoin::NetTransAmount) displays 0. Oh brother. Any ideas what could be wrong here? Thanks for any suggestions.

Linda

[LindaG]

Oh dear. Apologies. Invoices display is now right. I was using the wrong relationship for the display of the field.

But the selfjoin still won't work - it displays 0 in the Sum field. Why wouldn't it work?

Linda