How can I access the totals sum of a grid column?

[#1]

I have a grid

A   B

1   1/(1+2+3)

2   2/(1+2+3)

3   3/(1+2+3)

how can I get the desired results of column 'B' by using formulae, value of 'A' are coming from expressions so they keeps on changing.

Any thoughts?

Best Regards,

Gaurav Tyagi

[#2]

u can use this formule..for B field

B=A/Sum(A)

[#3]

your query will give

1/1

2/2

3/3

[MayilVahanan]

Hi

= A/ sum(total A)

Hope it helps

[#5]

I am using few variables and conditions to calculate the expression of A.

But thanks for the reply I will use it somewhere else.

I am using variables now. Because I am taking some dynamic values by user.

Best Regards,

Gaurav Tyagi

[sujeetsingh]

Variables are good options...

But in a simple way you can Total=sum (A) in load script and simply use ...as B =A/Total

[#7]

Yup I am using them

but your formula wont work in a grid coz as the dimension value will change the value of sum(A) will change with it

my equations are lil complex now, I have figured out how to do it, if anyone wanna know then I can write them here for u.

Have a nice day

Gaurav Tyagi

[sujeetsingh]

Gaurav i have asked you to calculate it in script.....got it or you can have a variable..as u used ..

[#9]

Hi Gaurav,

Can you please share your solution equations?  I have a similar situation and can use some help.

Thanking in advance,

Anthony

[#10]

Hi Gaurav,

Can you please share your solution equations?  I have a similar situation and can use some help.

Thanking in advance,

Anthony