Selecting & deselecting records included in a calculation_2
I think the original threat must have disappeared in the pile.
I have 4 tables: Person < Analyses < Dates< Activities. There are related thus:
Person::ID to Analyses::person
Analyses::ID to Dates::analyses
Dates::ID to Activities::DatesID
Activities 2 (TO of Activities) is related using Person::Dates_n to Activities::DatesID
In activities I've got a cumulative field for each activity, that gives me the time expended on a particular activity on a particular day.
I have a 0 or 1 toggle fields in Analyses and Dates. I included in the 'selective cumulative activity' field the calculation: Analyses_toggle(0 or 1) * Dates_toggle(0 or 1) * cumulative activity.
1. When I present cumulative values on the Person layout I can use the cumulative field to get a value for particular date (from Activities 2) or the total for a person (from Activities), but I've tried creating a field to pick up value created in the above calculation (tried: sum() and max()) but neither works. How do I get this value onto the Person layout?
2. The 2 toggle fields both, correctly, change the calculated values in Activities. However, when I try to present the value on the Person layout, I find that toggling Analyses immediately changes the value, but toggling Dates doesn't change the value until the Analyses toggle have been modified. NB. I've included a 'Commit records' in the toggle script. How do I get immediate updates to the calculation?
Did you define "selective cumulative activity" as a number field with an auto-entered calculation or as a field of type calculation?
Is "cumulative activity" a summary field?
In what table did you define "selective cumulative activity"?
1. "selective cumulative activity" is a calc field, not an auto-entered calculation
2. "cumulative activity" is a calculation field of 2 summary fields: Summary_reverse-Summary_running total [it is done this way because my records are listed in reverse order.
3. "selective cumulative activity" is on Activities and I've already been wondering if that is the wrong place.