How to calculate percent value for each row [SOLVED]

Applications Grid / Reports
#1

Hi All!
I’m dealing with some issues in the summary view of a grid.
I want to calculate the percent of a record, based on the SUM value of the column.

This is an example about what i want to obtain.

name value percent
name1 50 50%
name2 30 30%
name3 20 20%

Totals 100 100%

I hope somebody can give me some clues in order to solve this problem.
Thanks a lot!

#2

Re: How to calculate percent value for each row

You can in the event onRecord of your grid app, calculate the percent
Use the variable {sum_field} to calculate

#3

Re: How to calculate percent value for each row

Hi Max!
Thanks for the clue!
i did some research into the help about {sum_field} and i get success!

The following code works fine for me:

$pct_calculation = ({my_total}/{sum_my_total});
{percentage} = $pct_calculation;

Thanks for the clue my Friend!
Best!

#4

Re: How to calculate percent value for each row [SOLVED]

no problem, its good to know that you found the solution, this will help another users.

regards