Jump to content

Sum LineItems for Invoice total


This topic is 6537 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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. smile.gif

Linda

Link to comment
Share on other sites

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

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

Linda

Link to comment
Share on other sites

This topic is 6537 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.