Problem in calculating sum in a variable

Hi guys,
Can anyone tell me if i calculate sum of some variable it’s giving only the sum of the distinc values . But If i calculate using calculations by selecting the cell, It’s giving correct values . This is the calculation inside the section . If I use a variable inside the section ., it’s not showing correct results.

But I need it in seperate varibale.

I need to calculate the sum of answers for each section . I tried for each and for all…


pks (BOB member since 2004-07-11)

Take this calculation (that is correct) and convert it to a variable by going to Data>Define as Variable. Check evaluate formula in its context and compare this to the one you are creating and see what the difference is or copy the formula to your variable.


Michele Pinti (BOB member since 2002-06-17)