In some inherited code, I see group headers/footers have items like 'Sum of @numcount ' . I cannot get the sum of a formula field. Any thoughts?
137k 31 31 gold badges 261 261 silver badges 332 332 bronze badges asked Aug 25, 2010 at 21:23 2,638 5 5 gold badges 25 25 silver badges 24 24 bronze badgesWhen I do a Right click , insert sum, I dont see the formula field in the fields to summarize. Some how i can see them on the other machine. Looks like a version issue to me. Any thoughts?
Commented Aug 25, 2010 at 21:35Do you know what version of CR the reports were created in? What version are you using on your machine?
Commented Aug 25, 2010 at 21:39 11.5.3700.0 on both. I see this is not taking me any where :( Commented Aug 25, 2010 at 21:54 Can you provide the formula you're trying to summarize? Commented Aug 25, 2010 at 22:21 Cost = items * 10 I wanted to get the sum of cost (total cost). Commented Aug 25, 2010 at 22:45The only reason that I know of why a formula wouldn't be available to summarize on is if it didn't reference any database fields or whose value wasn't dynamic throughout sections of the report. For example, if you have a formula that returns a constant it won't be available. Or if it only references a field that is set throughout the report and returns a value based on that field, like "if =1 then 1" would not be available either.
In general, the formula's value should not be static through the sections of the report you're summarizing over (Though the way Crystal determines this is beyond me and this doesn't seem to be a hard and fast rule)
EDIT: One other reason why a formula wouldn't be available is if you're already using a summary function in that formula. Only one level of summaries at a time!
answered Aug 25, 2010 at 22:56 7,267 1 1 gold badge 18 18 silver badges 31 31 bronze badgesThanks. I was looking at why it wont list my formulae. Now I got it. I removed the constant and it shows up.