Skip to Content
0
Former Member
May 07, 2012 at 08:50 AM

Calculation Formula Question in Crystal Report

28 Views

Hi all, my name is Ryan

I Have a question for my crystal report. I have this report

PH EMPLOYEE NAME SALES POINTS

GH SALES MARKETING EMPLOYEES

DETAIL JARED 100

MIA 250

AARON 50

MICK 200

SARAH 25

GAIL 150

GF 775

**PH : Page Header

GH : Group Header

GF : Group Footer

I want to do calculation between (SALES POINTS details) /(Total in GF) but my total in GF is a formula based on three formula:

1st formula in the Report header(Suppressed) :

numberVar TotalSlsPoints;

whileprintingrecords;

TotalSlsPoints:=0;

2nd Formula in the Detail(Suppressed) :

numberVar TotalSlsPoints;

whileprintingrecords;

TotalSlsPoints:=TotalSlsPoints+{@Balance_Feb};

3rd Formula in the Group Footer (Not Suppressed and it is displayed in the GF like the explanation above):

numberVar TotalSlsPoints;

whileprintingrecords;

TotalSlsPoints;

So the report would be like this :

PH EMPLOYEE NAME SALES POINTS AVG

GH SALES MARKETING EMPLOYEES

DETAIL JARED 100 (100/775)

MIA 250 (250/775)

AARON 50 (50/775)

MICK 200 (200/775)

SARAH 25 (25/775)

GAIL 150 (150/775)

GF 775

Btw I use crystal report 2008. If you guys have the answer please reply coz' I already tried 100 ways to do the calculation but didn't find the right ones.

Thanks in advance,

Ryan