FMPros,

I have a running total summary field set up and I use it to gather
total prices from specific search criteria. I am looking for a way that
I can compare the results of each of these searches together on the
same page. Right now I am manually writing down the result of each
search, then charting them in excel, but I thought there must be a
better way of doing a side-by-side comparison in FMPro.

Any ideas?

Thanks in advance,

Jay

Did you look at the function "GetSummary" ? After sorting on the
argument, it shows the Summary on each of the corresponding records.
From that you may compare summaries.
Another route, avoiding sorting, is to make self relationships of the
fields involved and compare their SUM.
Remi-Noel


"Jay Valinis" <fmpro (AT) javelindesign (DOT) com> a écrit ...