2 Replies Latest reply on Sep 8, 2014 6:34 AM by tays01s




      Selecting & deselecting records included in a calculation


      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.

      2 questions:

      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?