Calculations using subtotals 2

[IanMac26]

I am using Crystal XI to do a Sales Analysis on 2 group levels. My groups are product and customer. At the detail level I have salesamount and costamount and have inserted summaries of both at product, customer and report levels. The subtotals show correctly, but when I calculate the profit margin (sales-cost)/cost*100 I get the correct answer at the product group level, but not at the customer level. This is most obvious when the customer has only bought one type of product, the subtotals are the same but the margins are different.

 

[IanWaterman]

How are you calculating profit margin at customer group.

You should use a formula in group footer

@CustPF

(sum(sales, customer)-sum(cost, customer)/sum(cost, customer)*100

Ian

 

[dgillz]

You probably should build in a check for cost being zero so you don't get a divided by zero error:

if sum({cost}, {customer}) = 0 then 0 else
(sum({sales}, {customer})-sum({cost}, {customer})%sum({cost}, {customer})

Also notice you do not need to multiply by 100 if you use the % symbol instead of the division /.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[IanMac26]

The 2 replies confirmed to me that I was doing the right thing. I re-entered the formulas(putting in the test for zero divisor and using the % operator), as I had done several times before posting. The formulas looked the same but now they work. :-D