IF Conditional in a Formula in PHP

Question

how can I do this little function in PHP, my specific doubt is in the part that I use the IF conditionals in the code that I share, this can't be run, I don't know if I can do something like that in PHP, how can I do this correctly. I really will appreciate your help!

function updateAvg_noi($bean, $event, $arguments)
         {
            $bean->avg_noi_c = ($bean->year_1_noi_c + $bean->year_2_noi_c + $bean->year_3_noi_c) / 
            (
                (if($bean->year_1_c == NULL){0;}else{1;}) + 
                (if($bean->year_2_c == NULL){0;}else{1;}) + 
                (if($bean->year_3_c == NULL){0;}else{1;})
            );
         }

Use the conditional operator, aka ternary: `condition ? true-value : false-value` — Barmar, Aug 21 '20 at 00:45
Does this answer your question? [How do I use the ternary operator ( ? : ) in PHP as a shorthand for "if / else"?](https://stackoverflow.com/questions/1506527/how-do-i-use-the-ternary-operator-in-php-as-a-shorthand-for-if-else) — Cornel Raiu, Aug 21 '20 at 00:46

score 1 · Answer 1 · answered Aug 21 '20 at 00:45

1

The ternary operator is what you are looking for in this case

function updateAvg_noi($bean, $event, $arguments) {
    $bean->avg_noi_c = ($bean->year_1_noi_c + $bean->year_2_noi_c + $bean->year_3_noi_c) / (
        (($bean->year_1_c == NULL) ? 0 : 1) + 
        (($bean->year_2_c == NULL) ? 0 : 1) + 
        (($bean->year_3_c == NULL) ? 0 : 1)
    );
}

answered Aug 21 '20 at 00:45

Cornel Raiu

2,758
3
22
31

Thank you very much, your proposal really helped me a lot. :) – Carolina VG Aug 21 '20 at 22:26

score 0 · Answer 2 · answered Aug 21 '20 at 01:10

This is just an alternative way of doing the calculation if you have lots of year inputs. Ex. year 4, year 5, ...

<?php

// Alternatives using array_sum

// Ex. Ternary operator
$numerators = [
    $bean->year_1_noi_c, 
    $bean->year_2_noi_c, 
    $bean->year_3_noi_c
];

$denominators = [
    $bean->year_1_c === null ? 0 : 1,
    $bean->year_2_c === null ? 0 : 1,
    $bean->year_3_c === null ? 0 : 1,
];

$output = array_sum($numerators) / array_sum($denominators);


/***********************************************************/


// Ex. Check is_null, inverse, cast to int
$numerators = [
    $bean->year_1_noi_c, 
    $bean->year_2_noi_c, 
    $bean->year_3_noi_c
];

$denominators = [
    (int)!is_null($bean->year_1_c),
    (int)!is_null($bean->year_2_c),
    (int)!is_null($bean->year_3_c)
];

$output = array_sum($numerators) / array_sum($denominators);

Thank you very much, this is more sophisticated and it also works for me. :) — Carolina VG, Aug 21 '20 at 22:28

IF Conditional in a Formula in PHP

2 Answers2