Skip to Content
0
Former Member
May 31, 2011 at 04:11 PM

Subtracting a specific condition from a total value??

848 Views

Hello, I am very new to Crystal Reports and I am the only one in my group using the software (which means I must become the expert--scary)

Anyway, I have two columns of data that I have entered via an excel spreadsheet. I could easily solve my issue using another column but I feel my issue can be solved writing a simple formula in Crystal Reports. Here is my issue:

Column 1 (C1) are line values of cost, the second column (C2) are account groups. I would like to write a formula that gives me a grand total of all of C1 minus a specific account group.

A $15

A $17

B $30

B $35

B $18

C $17

C $35

Gttl = $167

Formula

Gttl ($167) u2013 C ($52) = $115

I have tried this a few times, a few different ways

for example:

Sum({Item.C1}) u2013 ({Item.C1},{Item.C2},u201CCu201D)

But all I get in an error.

What am I doing horribly wrong?

Scott

PS: Again I am very new to this type of software. And thank you for your time.