We help IT Professionals succeed at work.

# how to do sumproduct in crystal

on
Medium Priority
1,082 Views
hi.. i have a formula in a excel spreadsheet which is:

=IF(C62=0,0,SUMPRODUCT(D5:D61,C5:C61)/C62)

iam in the process of converting those reports to crystal and am stumped as to how i can convert it into a crystal formula. Any help would be great.

Cheers
Comment
Watch Question

## View Solution Only

Commented:
Here is the general structure of the solution:

Step 1:  Create a formula (call is Accum) with the
following formula:
{table.field1}*{table.field2}

place that formula in the details section.

Step 2: Create a total field based on the Accum formula.  Make it a sub-total if that is appropriate.

Step 3:  Create a formula with the following expression:

if sum({@accum}) = 0 then 0 else
sum(@accum}/{table.field3}

where field3 is equivalent to cell C62.

There is probably more to your question, but this is what I can contribute with the info I have right now.

Commented:
Thanks..i think i have figured what i have to do..i will get back to you once i have verified that the formula works.
Cheers

Commented:
the formula works..thanks