Jeremy Campbell
asked on
How to call on a Variable in a formula.
https://www.experts-exchange.com/questions/26967600/How-to-Omit-Suppressed-Values-in-Group-Sum.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! :(
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! :(
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
> 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
> 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
....
ASKER
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!