Formula as a Column Total? 1

[beckk3]

Can you specify a custom formula for a column total?

For example.

Column 1 = Total number of open accounts
Column 2 = Total value of all open accounts
Column 3 = Column 3 / Column 2

A simple summary on column 1 and 2 is reasonable but it isn't logical for Column 3. Column 3's total should be calculated as the sum of column 2 / sum of column 1.

I would like to display Column 3's results in line with Column 1's and 2's summaries.

Suggestions?

 

[focwizard]

If you use a COMPUTE to get the third column, then use 'ON TABLE SUMMARIZE' , the COMPUTE calculation will be redone using the summed values of columns 1 and 2.

 

[beckk3]

Just returned from vacation. Thanks for the input. It really helped meet the business requirements.