CalcSum Problem

hi dear,

'm using CALCSUM for calculating my colm’s total. like this


row1 5

row2 8

row3 1

total 14

i have totalling field which is text and used to choose the no of lines needed to be calculated. so i have placed the code in the validate field of totalling

IF NOT (“Bifurcation Type” IN [“Bifurcation Type”::Total,“Bifurcation Type”::“End-Total”]) THEN
FIELDERROR(“Bifurcation Type”);


the problem 'm facing is every time i change the totalling , the result adds by itself!

Please can any1 help me here.