hi. am very new to navision and am trying to come up with a code to sum up savings in a sacco,
theres a members table that has all member details including monthly contribution and total savings, which should be automatically incremented when a member enters a monthly contribution.
i managed to write a code to pick the member no, and monthly contribution but now i cant write the code to sum them up 
the form looks like below:
Hiā¦Welcome to DUGā¦
I cant see the form.can you check?
ok this is awkward am trying to attach the screenshot iv vain [:(]
anyhow,
You have a table called āmembersā with all member details including monthly contributionā¦
In the same table you have total savings which should be the sum of monthly contributions for same memberā¦
is it so?
If yes,
Set Total Savings to FlowFiled and CalcFormula as
Sum(āMembersā.monthlysavings WHERE (Member No.=FIELD(Member No.))) (you need to set exact field names)
yes both are in the same tableā¦
If yes,
Set Total Savings to FlowFiled and CalcFormula as
Sum(āMembersā.monthlysavings WHERE (Member No.=FIELD(Member No.))) (you need to set exact field names)
Thank you Mohana! Iām sure this solution worked. Everyone always begins from somewhere indeed!