Calculated Field on Summary

Applications Grid / Reports
#1

How can you create a calculated field on a summary? I have two fields that are being summarized and I want to calculate a new fields that divides those two fields.

Thanks,
Frank

#2

Re: Calculated Field on Summary

create a new field, on the onRecord event:
{new_field} = {field1}/{field2};

#3

Re: Calculated Field on Summary

I am still a little confused. I don’t see any events in the summary section. I see them in the grid section but not the summary section. If I create a field in the grid section, then in summary section, it only allows me to sum, average, min or max that column. That doesn’t work in this situation because I need to do the calculation after the summary has taken place. Any other ideas?

1 Like