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