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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.