• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 375
  • Last Modified:

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?
0
StinkyPete1
Asked:
StinkyPete1
  • 2
  • 2
2 Solutions
 
mlmccCommented:
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
 
James0628Commented:
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
 
StinkyPete1Author Commented:
Thanks for your help. Turns out I had the wrong field suppressed and was viewing a different table's total.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now