This script will return a numerical result which has been rounded to the specified number of digits from the decimal point. It will round up or down depending on which is the closest digit.
FORMAT: ROUND (number, number of digits)
- Number: A numerical expression.
- Number of digits: If positive, the number of digits to show to the right of the decimal point.
$a = length instances where row = "Team 1"
$b = length instances where row = "Team 2"
Variables used to calculate the total length of time for the instances in each given row.
$c = $a + $b
Create a variable to add the results of variable $a and variable $b.
$d = ($a/$c)*100
Create a variable to calculate the % total possession for "Team 1" and adds the "%" symbol.
$e = round($d,0) + "%"
Variable rounds down the numerical % to zero decimal places (e.g., 30% rather than 30.234%).