Calculated result only shows up in one record

[Marcel1]

Hi,

I have a table with a large number of records, and a field called "result". Result can have one of 8 different possible values. I would like to create a field that automatically adds up how many records in the table have value1, value2, ... value8 in the field "result".

So, I created a global field for each potential value in the field result (g_value1, g_value2, ...g_value8) , created 8 additional instances of the table, and linked them to the original table by relating the "g_valueX" fields to "result" in the original table. I then created fields that count all records, calculated from the perspective of table instance 2, instance 3, ...instance 8.

The problem: The solution seems to work correctly, but the 8 count_records fields only have entries when I am looking at the last record in the original table. If I go to any other record, the fields are blank. Why is this, and is there any way to fix it? I think I have to trigger the calculation to occur in all records, but I am not quite sure if this is the problem, or how to do it.

Any thoughts welcome.

Many thanks.

[mr_vodka]

Why all these global fields? i think you would be better off with something like this.

[Marcel1]

Right, I can see how something like ( Case Table::result = "value1 1"; 1) could be handy. But then how do I get a sum of these values for a subset of records in my table?

M