Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by TKUMI

  1. TKUMI

    Sum of sums?

    I am using CR XI. I have entered: sum ({Sum of INVOICES.INV_AMOUNT}) - ({Sum of INVOICES.PAID_AMT}) My result is: sum (1,848.79) - (148.95) I just can't get it to actually subtract. I've tried deleting the spaces around sum and -, but it just changes the 'text' output. I thought I was doing...
  2. TKUMI

    Sum of sums?

    Can you create a sum of sums, or subtract one sum from another? I have two sum: Sum of INVOICES.INV_AMOUNT and Sum of INVOICES.PAID_AMT I just want the total balance, ie: Sum of INVOICES.INV_AMOUNT - Sum of INVOICES.PAID_AMT What is the formula for this? I've been trying different things but I...
  3. TKUMI

    CR XI condensing results

    I'm brand new to CR so I'm still learning the basics. I have a report that shows all of the customers that have purchased all items of a certain brand. It's broken down as: Brand Item1 Cust1 Cust2 Cust3 Cust2 Item2 Cust1 Cust2 And so forth. But, I only want to display each customer...

Part and Inventory Search

Back
Top