[RESOLVED] rounding a sum for unknown values

[tito]

Hi,

I have a bunch of inputs to put in db

input[0]
input[1]
input[2]

etc...

they all carry integer values and their value sum must be equal to 100

for example

input[0] = 20
input[1] = 40
input[2] = 40

When I submit, I easily do the sum verification and make sure it is 100.

Now, those values are not mandatory, but I must insert something in database.

(if one input is filled all must be filled. Or all must be empty)

If they have 4 empty inputs I do 100/sizeof($array) and I get 25 each and it's perfect

But if it's not divisible, example 3 inputs at 100/3 will give me 33 for each and a total of 99

So how can I do for all empty: make division floor(100/total of inputs) and if the total of all is not equal to 100, adjust the last one to make it so.

e.g in example above the last 33 will become 34

and I put all those new values back in an array with their same keys

thank you.

[johanafm]

maybe

$floor = floor(100 / $numElements);
$adjust = 100 - ($floor * $numElements);

$elements = array();
for ($i = numElements; $i > 0; --$i) {
	$elements[] = $floor;
	if ($i <= $adjust) {
		++$elements[count($elements) - 1];
	}
}

[tito]

thanks. I tried with 3 items with the hope to get 33,33,34 and when I do a print_r($elements);exit; I get an empty array

[tito]

hey that works, thanks.

you forgot to put $ in
for ($i = numElements; $i > 0; --$i)

but it works.

thanks again

[tito]

the only issue i have left is the keys not matching

the first array where i get the $numElements (sizeof($array))
Array ( [0] => ooo [2] => ppp [3] => vvv )

they have their own keys. And the results have different keys.

Array ( [0] => 33 [1] => 33 [2] => 34 )

[tito]

Any existing key can be assigned to new array, as long as both arrays have same keys, because it will do insert according to key

[johanafm]

Where does the ids 0, 2, 3 come from? If you allready know them, you could

$keys = array(0, 2, 4);
$i = count($keys);
foreach($keys as $k) {
    $elements[$k] = $floor;
    if (--$i < $adjust) {
        ++$elements[$k];
    }
} 

[tito]

I already know them.
That takes care of the keys, but now I get empty values

Array ( [0] => uuu [2] => nnn [3] => ooo )

Array ( [0] => [2] => [3] => )

[tito]

sorry it works.
I had introduced a new element in there

if (empty($elements))
{

do stuff
}

but $elements appears not to be empty. It has no value, but has a key.

[tito]

ok, I am doing now

if (array_sum($elements) == 0)

and that works

[tito]

All is good. Thank you very much for your help. I had been struggling with this for a week now.