We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

How to call on a Variable in a formula.

Jarred Meyer
Jarred Meyer asked
on
Medium Priority
683 Views
Last Modified: 2012-12-26
https://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_26967600.html

I am using this to total some information and eliminate duplicates. However, I need to use the totals being produced within the footer section in a formula. If I browse that field it shows zero, even though when placed in the footer it does give the correct total..

Also, I also need to be able to average an unsuppressed field in my details. Can this be done using the same method, variables?

Thanks.. P.S. I am very much not liking having to create all these fomulas just to sum my unsuppressed fields.. If there is an easier way to do this please someone tell me! I can't figure out why Crystal would not have incorporated this feature! :(

Comment
Watch Question

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Jarred MeyerProduction Manager

Author

Commented:
mlmcc: I only wish I knew more about these programs to make such a suggestion :) I know how I would like to see it work.. Probably have a checkbox in the Section Expert that would say something like, checked to ignore suppressed values in calculations or unchecked to calculate suppressed values.. It just seems like that would save a lot of time.. I guess it will be different as I get to know the software better..

Aside from my bickering about the software :)

James your method is definitely easier to work with and for me to understand. Nonetheless either will work.. At least I know there is an alternative to the variables.. I'm sure in due time I will have a much better handle on those though..

Let me work with this now for a bit and I'm sure I will be back later today with more questions... Creating this report is definitely proving to be a challenge.. But I will say that I am learning A LOT in the process!

Thanks again guys!
CERTIFIED EXPERT

Commented:
 > Probably have a checkbox in the Section Expert that would say something
 > like, checked to ignore suppressed values in calculations or unchecked to
 > calculate suppressed values.

 That's actually an interesting idea.  I don't know how often it would really be needed by CR users in general, but it seems doable and would certainly be useful at times.


 FWIW, there are some things that running totals just can't handle, so if you work with CR very much, you'll probably need to use variables sooner or later.  But if running totals give you what you need, I see no reason not to use them.

 James
....
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.