Sum field after parameters

[Hasnas]

Hi,

Quite new to FM so haven't learnt all the functions out there. Thought that someone here might know a good way how to script what i need.

I've got three fields in a table, Provider, Group (1,2 and 3) and Value. The provider will change but the groups won't. I need to summarize the value for all groups for all providers (3 values per provider).

Is there a way to summarize in for example a calculation the value for Provider A for group 1 and so on which i can then insert in to another table?

Thanks in advance!

Hans

[bcooney]

Hans,

It seems to mean that you need to think about structuring your data into three tables: Providers, Groups and a join table that stores the combinations of Providers and Groups "ProGroup".

In the join table, ProGroup, you would have your Value field.

Then, by creating a sub-summary report based on ProGroup, you will be able to report on totals by Provider, by Group. If you do Finds in the join table, you can limit your report to a specific Provider and Group (and perhaps date range?)

hth,

Barbara

[Hasnas]

Ahh that will work! Thanks Barbara