Table - calculation adding up funny

[vJnr]

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

[whyisthisme]

Well your total income formula is totalling all the Cell7s in all the Row2s including the row2 where the formula is. Try renaming your total row to something else.

[vJnr]

Yup all working now, thanks man