I am losing my mind.... (1 Viewer)

aftershokk · Apr 6, 2010

It has been many moon since I used Crystal.

I have a basic rpt.

Column 1 sums unit_a in the report footer field = 6
Column 2 sums unit_b in the report footer field = 2

I gave a formula in the report footer field to get a total of 8 units

I want to divide column 1 total of 6 by the total of 8 to get 75% but I just cannot get it to work

please help!

SOS · Apr 6, 2010

Just create another formula which does the divide fielda by fieldb and then put it in the footer. It will do the job.

aftershokk · Apr 6, 2010

it keeps coming back as 1.00

Sum ({report_qry_crystal.units_a})/Sum ({@total})
6 / 8

SOS · Apr 6, 2010

Don't include the SUM part. The footer takes care of that.

SOS · Apr 6, 2010

Just use:

{report_qry_crystal.units_a}/{@total}

SOS · Apr 6, 2010

And actually, you wouldn't use @Total you would use COLUMN B

aftershokk · Apr 6, 2010

a is 6
b is 2
the total is 8

I want to divide a / total

I still get 1.00?

aftershokk · Apr 6, 2010

I just figured it our by multiplying the formula by 100 to get a percent - thanks for your help!

SOS · Apr 6, 2010

Okay, let's think about this for a minute.

If you put a formula in to the footer that has

Sum(report_qry_crystal.units_a})

then it sums all of A.

If you put a formula into the footer that has

Sum({report_qry_crystal.units_a} + {report_qry_crystal.units_b})

That should give the total sum

If you use a formula that has

Sum({report_qry_crystal.units_a})/
Sum({report_qry_crystal.units_a} + {report_qry_crystal.units_b})

that should get you what you need - theoretically. (fingers crossed)

SOS · Apr 6, 2010

ah, okay glad you got it.

I am losing my mind.... (1 Viewer)

aftershokk

Registered User.

SOS

Registered Lunatic

aftershokk

Registered User.

SOS

Registered Lunatic

SOS

Registered Lunatic

SOS

Registered Lunatic

aftershokk

Registered User.

aftershokk

Registered User.

SOS

Registered Lunatic

SOS

Registered Lunatic

Similar threads

Users who are viewing this thread