Easy Question - Grand Totals 1

[Estandridge]

In CR 8.5, I am trying to use a formula that will calculate a target percent from a grand total in the footer section. The question is, in a formula, any formula, how would I use a grand total (summery) in a formula, say X/{grand total}? I hope there's an easy way to do this, don't want to spend all week making formulas.

Thanks much!
Eric

 

[lbass]

Try:

x/sum({table.field})

...where {table.field} is the field you are grand totaling.

-LB

 

[lbass]

I was assuming you were summing, but if you were counting, it would be the same syntax:

x/count({table.field})

-LB

 

[Estandridge]

I think that's pretty much what I have.. there are several formulas that I'm using but they aren't returning the right number.. here's an example of one:


(Sum({@jan2}, {@Customer}) * .16017) + Sum({@jan2}, {@Customer})

Where Jan2 is the total of sales for a particular customer.. The formula above is suposed to calculate a target dollar amount. I set it up as having a grand total of @jan2, but don't know the right way to use that in a formula in the footer section. Thanks for the quick responce by the way..

Thanks,
Eric

 

[Madawc]

Once you've created the grand total, it will be available as a field along with the database fields, parameters etc. You should find it prefixed by a Greek symbol (not one I can figure how to post here) and saying something like Report Area: Sum of

Madawc Williams (East Anglia, UK)

 

[Estandridge]

Hey Madawc, thanks for the information.. I never noticed that before.. was thrown into doing crystal reports with no training what-so-ever, so I didn't know little things like that existed.. LOL Thanks much my friend.. it's appreciated.

Eric

 

[lbass]

Your formula would be for a group footer, not a report footer. If you want this calculation at the report level, then use:

(Sum({@jan2})*.16017) + Sum({@jan2})

-LB