SUM positive and negative amounts

I am in the process of creating an invoice that  gives a balance due - however all credits and charges must be summed together to give a balance due.
The issue I am running into is that for some reason the result  i am getting does not equal what  I am expecting.

sum ({bilingitem.amountdue}) where billing.item is a combination of records with values such as $200, $47.30, -$238

Open in new window

Who is Participating?
mlmccConnect With a Mentor Commented:
Is the Sum({MoneyField},{AccountId}) not working?

You can do it with formulas and variables.

DO you have all the values in the one field?  Are there both positive and negative values?

What type is the field that you're trying to sum ?

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

EMSI-InfAuthor Commented:
MLMCC: I have the following scenraio on my invoice:

Code 7  -   Units 20 - Amount_Due - $140
Code 10 - Units 5 - Amount_Due - $100
Code 998 - Units 4 - Amount_Due ($80) * this is a credit amount
Total Due on Invoice - $160 (this would be a sum of Code 7 + Code 10 + Code 998)
In my Crystal report _ have a statement that says SUM({Amount_Due})

SPykair - I am trying to SUM (Money type fields) should I convert these to integers?

EMSI-InfAuthor Commented:
Hi - can anyone help me with the issue described above?
EMSI-InfAuthor Commented:
Thanks - that helped - had to pull up other Crystal Reports doing something similiar and seems I am ok now - you guys are great out here. Please keep up the good work
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.