Crystal Reports XI Cross Tab

I need to have a difference (qty ordered - qty shipped) as the total in a crosstab report. The crosstab only will sum the numbers but I need the difference between the 2 to display.

Any Thoughts?
StinkyPete1Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
James0628Connect With a Mentor Commented:
Any chance that QtyOrdered is positive and QtyShipped is negative, or vice versa?  That's the only way that I can think of for a summary on {QtyOrdered} - {QtyShipped} to give you a result that looks like the two values (ignoring the signs) added together.

 If they don't have opposite signs, then there must be something else going on.  If you could post the report, as mlmcc suggested, then maybe we can spot the problem.

 James
0
 
mlmccConnect With a Mentor Commented:
You can create a formula as

{QtyOrdered} - {QtyShipped}

Use the formula in the cross tab

mlmcc
0
 
StinkyPete1Author Commented:
Unfortunately, I already tried that but it still sums the numbers. It is almost as if it ignores the "-" and just adds the numbers.
0
 
mlmccCommented:
Can you upload the report?

mlmcc
0
 
StinkyPete1Author Commented:
Thanks for your help. Turns out I had the wrong field suppressed and was viewing a different table's total.
0
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.