GRAND TOTAL QUESTION

[Cherrel]

Greetings.

I am currently composing a report in Crystal 7.0 that is to calculate various "GRAND TOTAL" values on inventory items that are located within my report.

I have no problems "sum"ming up other columns at the end of my report (total number of inventory items that meet each individual criteria). The problem arises when I am trying to get a GRAND TOTAL of a column of Inventory Value. I am able to generate an TOTAL AMOUNT at the end of the row for a specific piece of inventory, but when I go to get a GRAND TOTAL, I get *NO* Grand Total choice from INSERT | Grand Total (is greyed out).

I generate the TOTAL AMOUNT (for each line item/row) from a formula that I created:
Sum ({@SUM OF A & F}, {item.in2}) * {item.in5}

THIS is where I am having a problem. I need to find an alternative method of getting a GRAND TOTAL for the end of this report because apparently in Crystal, I am unable to "GRAND TOTAL" an amount that was derived from a formula.


ITEM NRFI RFI TOTAL # OF ITEMS TOTAL VALUE
---- ---- --- ---------------- -----------
XX01 01 03 04 $14.00
_______________________________________________
GRAND
TOTALS: 01 03 04 $14.00
(hopefully)
NRFI is calcuated with @IF=A
**if {equipment.eq6} = "A" and
{equipment.location} = {locations.location} and
{equipment.location} <> &quot;DRMO&quot; and
{locations.type} = &quot;storeroom&quot; then 1

RFI is calcuated with @IF=F
**if {equipment.eq6} = &quot;F&quot; and
{equipment.location} = {locations.location} and
{equipment.location} <> &quot;DRMO&quot; and
{locations.type} = &quot;storeroom&quot; then 1

TOTAL NUMBER is calculated with @SUM OF A&F (sum)
**{@IF = A} + {@IF = F}

TOTAL VALUE is calculated with @SUM OF INVENTORY VALUE
**Sum ({@SUM OF A & F}, {item.in2}) * {item.in5}
item.in2 is the MODEL NUMBER
item.in5 is the ITEM COST

If anyone can help me create a formula (or other method) to come up with a GRAND TOTAL that would be great! Like I said, I have no problems coming up with NRFI/RFI/TOTAL NUMBER OF ITEMS (Grand Total), just with coming up with the GRAND TOTAL of INVENTORY VALUE.


Thanks!!
Cherrel. |-)

 

[dgillz]

Change the total value formula to:

{@SUM of A&F}*{Item.in5}

Then you should be able to grand total it.

Think of SUM, or any other summary function like AVERAGE or COUNT as a vertical function. Do not use sum to add a virtual column to your report, just use field names, operators and functions.

Make sure the formula for {SUM of A&F} does not have any summary functions in it either. If should just be A+F.

Let me know if this is a problem. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[Cherrel]

dgilz,

I changed the formula to {@SUM of A&F}*{Item.in5}
and now most of my results are $0.00 - and the ones that do produce an inventory amount are wrong.

I know that when I run the &quot;original&quot; total value formula it works (produces me the right amount) because I have manually checked the answers.

I also checked to see if I had put any sums in the formulas for @SUM OF A & F and there are none. (There is a SUM that I used from INSERT | SUMMARY to get the grand total amount.)

Help!
Cherrel.

 

[Cherrel]

I GOT IT!! WHOO HOO!

I simply performed a GROUP BY (don't ask me why) and then it just fell into place.

The inventory total works and most importantly, the GRAND TOTAL works!!!

Thanks so much! :-D
Cherrel.