Skip to Content
avatar image
Former Member

CR XI R2 - Sum columns at end of row

I have a table with 3 columns and I'm trying to sum the results of the 3 in the 4th column. But I'm confused as to how many formulas I need and where they go.

Putting the formula below in the Column 4 Details give a result that is only counting Column 3. I'm not sure if this is supposed to be running total.

Group Header: Col 1 Col 2 Col 3 Col 4 ____ Details: Text1 Text2 Text3 ColumnSum

My calculation formula (Crystal syntax):

WhilePrintingRecords;
numbervar x;
numbervar y;
numbervar z;
numbervar ColumnSum;
ColumnSum:= x + y + z ;

if {@Text1}="N/A" then ( numbervar x := 0 ; ) else if {@Text1}="Low" then ( numbervar x := 1 ; )...etc.  ;
if {@Text2}="N/A" then ( numbervar y := 0 ; ) else if {@Text2}="Low" then ( numbervar y := 1 ; )...etc.  ;
if {@Text3}="N/A" then ( numbervar z := 0 ; ) else if {@Text3}="Low" then ( numbervar z := 1 ; )...etc. 

Thanks in advance for any help

Edited by: GenePoz on Jun 24, 2010 11:57 PM

Edited by: GenePoz on Jun 25, 2010 12:02 AM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 24, 2010 at 10:04 PM

    Hi Gene,

    If this is on the Detail section then you don't really need a running total but you will need the variables. Try this:

    numbervar x;
    numbervar y;
    numbervar z;
    numbervar ColumnSum;
    ColumnSum:= x + y + z ;
     
    if {@Text1}="N/A" then ( x := 0 ; ) else if {@Text1}="N/A" then ( x := 1 ; )...etc.  ;
    if {@Text2}="N/A" then ( y := 0 ; ) else if {@Text2}="N/A" then ( y := 1 ; )...etc.  ;
    if {@Text3}="N/A" then ( z := 0 ; ) else if {@Text3}="N/A" then ( z := 1 ; )...etc. ; 
    
    x + y +z;

    The reason it only shows column 3 is because that's the last thing the formula evaluates. You need to tell have the formula sum the 3 columns.

    Good luck,

    Brian

    Add comment
    10|10000 characters needed characters exceeded