I have an Outlook Style grouped grid, with several levels of grouping. There are summary cells in the group-by rows. Let's say I have three columns, A, B, and C. My code successfully calculates values for the summary cells for A and B in each group-by level.
I want the summary cells for C in each group-by level to show the ratio of the summary cell value for A and the summary cell value for B in that level. Is there a formula that I can use that will refer directly to the summary values in other cells of the group-by row that contains the target of the formula? The simplest one is [A]/[B], but it returns #VALUE!.
Also, is there a reference that documents the syntax af the Calculation Engine's formulas?
Interesting. It seems that the entire syntax (whatever it actually is) could be documented in a few pages. Thanks again for the help.
Mostly from experience I've used it since it was introduced. The forum for WinCalcManager was helpful and there are some sample programs provided I worked with also. There are a few gotchas along the way. Some limitations using iif.
Unfortunately I hate to tell you that there isn't a way to refer to other groupby formulas ie subtotals. I imagine you may have used this capability in Crystal Reports?
In 2008.2 there is a problem where inline formula based summaries are not painting which I am trying to help get resolved so if you are using that version yet you may experience the magic disappearing trick.
That worked. Thanks!
Did you just know this from experience or is there a document somewhere that explains the Calculation Engine formula syntax? What if I wanted to refer to summary fields in the group-by rows that are one level down?
I think you will want Sum([A])/Sum([B]). Give it a try.
Nick