Percentage of Total Value for each row in a list report

[cognovice]

Hi All,
I want to create a new column (% of Total_Value) for each row of information which calculates % of Total_Value column with respect to grand total.  I have attached the sample report header with one row of information. 

Grand total of Total_Value (Column R) is 4,696,873.36

% of Total_Value for row 1 should be (Column R / Grand Total of Total_Value * 100) which is nothing but (1219.66/4696873.36)*100 = 0.2596

Where as what I am getting is 0.0008199 which is wrong.

Could you please assist me in achieving the above.

Regards,
R

[hespora]

Well, what's you definition for the [% of total_value] column? It should be (on relational):

Code Select Expand


[Total_Value]
/
total(
  [Total_Value]
  for report
)

Possibly replce "for report" with other aggregate levels if you want to divide by subtotals

[cognovice]

Hi Hespora,
Thank you very much for your response.  It worked.


Regards,
R

[hespora]

Wonderful, glad I could help!