Need help with straight table

[venkatg6759]

Hello ,

I have a table like this

NO    Name             Field        bad    

11      tradelink         dollar        10%

12      capital             security     20%

11        tradelink     dollar        20%

If i am doing the sum of rows i am getting

                                              30%

11      tradelink         dollar        10%

11      tradelink     dollar            20%

How can i aggregate and show them only one time like this

11    tradelink           dollar           30%  

Please help me how to aggregate or any other methods.

Thanks,

[DavidFoster1]

Hi Venkata

In your example, the second table is not consistent with the first one. Also can you confirm the expression you are using for 'bad'?

[CELAMBARASAN]

Hi,

NO    Name            Field        bad  

11      tradelink        dollar        10%

12      capital            security    20%

131        tradelink    dollar        20%

First row is NO field value is different. How come it have to merge in to single row?

[venkatg6759]

sorry both the nos are same .I misstyped it . tradelink has only one no.

[venkatg6759]

Hi David,

this is how we are doing %bad = sum{<field=>}bad/(sum({<field=>}bad+sum{<field=>good

We are having weights as well by which we calculate in this way

sum{<field=>}bad/(sum({<field=>}bad+sum{<field=>good * Weights