a simple form

catherine.ndavi · August 24, 2011, 9:08am

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:

mohana_cse06 · August 24, 2011, 9:14am

Hi…Welcome to DUG…

I cant see the form.can you check?

catherine.ndavi · August 24, 2011, 9:40am

ok this is awkward am trying to attach the screenshot iv vain [:(]

mohana_cse06 · August 24, 2011, 10:29am

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)

catherine.ndavi · August 24, 2011, 10:35am

yes both are in the same table…

mohana_cse06 · August 24, 2011, 10:37am

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)

catherine.ndavi · April 10, 2015, 6:25am

Thank you Mohana! I’m sure this solution worked. Everyone always begins from somewhere indeed!