column Total as Percentage based on Expression Total

[#1]

Hi all

By using the expression

Rangesum ((avg(if([TEST VALUE]>90 and [TEST VALUE]<=100 , [TEST VALUE]))*Avg(Weight)/100) +
(avg(if([TEST VALUE]>80 and [TEST VALUE]<=90 , [TEST VALUE]))*Avg(Weight)/100) +
(avg(if([TEST VALUE]>70 and [TEST VALUE]<=80 , [TEST VALUE]))*Avg(Weight)/100) +
(avg(if([TEST VALUE]>65 and [TEST VALUE]<=70 , [TEST VALUE]))*Avg(Weight)/100) +
(avg(if([TEST VALUE]>30 and [TEST VALUE]<=65 , [TEST VALUE]))*Avg(Weight)/100) +
(avg(if([TEST VALUE]<30 , [TEST VALUE]))*Avg(Weight)/100)

I am getting values 

Employee Band	Total #
I	56.10
II	44.40
III	45.88
IV	43.84
V	43.94
VI	43.88
	278.05

Now i want the Total value   ie 278.05 for the next expression to calculate the percentage of utilization for the employee band

for example for band 1 i need to display   56.10/278.05 *100 =20.18

Please advice

Thanks in advance

[Anonymous]

Hello Villa,

try like this. create another field like this in ur script.

(Total#/Sum(Total#))*100 AS Band_perc

[#3]

HI Venkat

The column TOTAL# is a result of the above script and its not a direct value from source

[#4]

Any Sollutions

[Anonymous]

You are getting value for total field na, u can write same logic on that expression...

[vardhancse]

as its a expression total, i think we can not use that for calculation