Error In Summission of data

[#1]

Hi,

I have a table with following load script:-

Table

Load

subject,

marks

from table_name;

While using sum for this table, the total summission comes as double:

Total

Load

'Total' as [Total]

sum(marks)

resident Table;

ex:-

CHE     10

Math     10

Fetching data from total table:-

Total     40

Is there any problem with load script or any unidentified loop works. Need help.

Thanks for help...

[#2]

Also, While creating the same table using group by doen't work as I don't need to group the fields , Whole sum is required.

And Load

sum(marks)

resident Table;

provides same output as Total     40

[giakoum]

Looks like the problem is your data. Could you please provide sample data? QV does not double anything unless it is there ...

Where do you see that 40? In a chart? a sample app would help.

[#4]

Thanks, its done now.