Formula for Summary Across Hierarchy
Posted on 2004-08-16
I am working on a report that uses group by hierarchy feature. I can get summaries for two columns at different levels by ticking 'summary across hierarchy' box. But I can't do calculations over the summarized fields.(summary across hierarchy) using formula.
In fact, if I don't tick 'summary across hierarchy' box, the summary value will not show up in preview as well. Also I notice, when I was editing
the formula, I click on the summary field available( this was generated by inserting summary and tick 'summary across hierarchy') , it shows
If I just use this as content of the formula, it will also not show anything when previewing it.
This doesn't happen to normal grouping. I guess Crystal is doing something special to 'summary across hierarchy'
I would like to know how to use formula or function to get these values so that I could do further calculations.
Thanks in advance for your help.