AnsweredAssumed Answered

help with calculating within a selection

Question asked by d.vanlooij on Oct 11, 2011
Latest reply on Oct 14, 2011 by d.vanlooij


help with calculating within a selection



I have a problem with my datbase which I am building. 

Background info: 1 table, name:production, is filled with production data, time, date, target, realisation, workplace, etc.
 1 table, name: settings, is filled with global fields, one of them is total_goal_workplace.

My problem: I have made a script which says:
 go to table production,
 omit records not workplace 2
 set variable $goal1 with value: sum(production::target)
 go to table settings
 replace field contents [settings::total_goal_workplace; $goal1]

but my result is not the total of al the values in the records of target.

please advise me