Hi guys
Just a quick question on calculation in tables.
I have a few fields including a total field, total field all working fine. But I also want to get a grand total of the total field, but the calculation comes out funny e.g 1+1=3 or 3+1+1+1=21?
I've looked at a few other post to get this code.
My TOTAL INCOME FOR ACTIVITY code below
Form.budgetDetailsoption2_pg.budgetdetailsoption2_sf.Table1_sf.Table1.Income.Row2[5].Cell7::calculate - (FormCalc, client)
$.rawValue = sum(Table1.Income.Row2[*].Cell7);
Form.budgetDetailsoption2_pg.budgetdetailsoption2_sf.Table1_sf.Table1.Income.Row2[5].Cell6::calculate - (FormCalc, client)
" .Cell6);"
" .Cell5);"
" .Cell4);"
My Total code is just $.rawValue = Cell4 + Cell5 + Cell6 (this is working ok)
I'm just wondering why my TOTAL INCOME FOR ACTIVITY is adding up funny?
Thanks