adding a calculated formula

[villica]

I have a report with many detail lines as follow

detail a qty * cost
detail b qty1 * cost1
detail c qty2 * cost 2



I want a running total or a gran total of the resutl of every detail line. Is this possible on crystal 6.

thank you kindly for any suggestions.

 

[synapsevampire]

I can't recall if CR 6 supports Running Totals, but you could just create a formula with all of them added together:

(qty * cost)+(qty1 * cost1)+(qty2 * cost 2) etc.

Or if you want totals for each, you should be able to just right click each formula you've created and select Insert->Summary and build/display it at the levels desired.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[villica]

Unfortunatly on crystal you can not right click on a formula field to get a total

this is what I basically like to happen
total runnig total
detail a 1 * 25 25 25
detail b 5 * 30 150 175
detail c 5 * 5 25 200

grand total 200

 

[synapsevampire]

Fortunately, you can right click on formulas to get a total, depending upon the formula, what you're displaying isn't the same thing though.

A simple way to accomplish what you want is to add in additional formulas:


detail a 1 * 25 25 25
detail b 5 * 30 150 175
detail c 5 * 5 25 200


The second column (qty*cost - which you represented with values instead of fields) I'll assume is just representative of the formula used for the Total, so I'll ignore that.

The Running Total for Detail A is the same as the formula, so just use it.

Now for the running total on the B detail, use:

(qty*cost)+(qty1*cost1)

Now for the running total on the C detail, use:

(qty*cost)+(qty1*cost1)+(qty2*cost2)

Grand Total is everything.

etc.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[dgillz]

villaca,

does details a b and c actually refer to thre separate details sections of your report, or does it represent one detail section with 3 records? Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[villica]

Hello dgillz

they are separate details . I have tried everything. I am ready to pull my hair out

 

[dgillz]

I beleive SV's formulas should work. Have you tried this? Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[villica]

Hi Dgillz. I apologize but what is a svs formula.

 

[dgillz]

SV's means SynapseVampire's post. I don't like to spell out SynapseVampire because its too many letters.

Did you try the formula that SynapseVampire suggested?
Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com