2.4.3 How to Adjust or Override a Previously Calculated Value

jadefortunato
jadefortunato
in Modeling

In the video for this section (which is great because it explains how the formulas work, btw), using a boolean to tell the system to calculate using a different value is called a "best practice."

 

Why?

 

Specifically, as I see it, the boolean creates an entire line item full of cells which need to be referenced every time the total is calculated. Wouldn't it be more efficient to change the formula in the "Final Forecast" row to "IF Override Forecast > 0, THEN Override Forecast, ELSE, Initial Forecast"?

Tagged:

Comments

  • Misbah
    Misbah

    @jadefortunato 

     

    To me that basically is an additional check, if only that boolean box is checked by the user then only Override Forecast will be pulled even if Override Forecast line is populated.

     

    However I have seen many clients who have asked us to do away with such an additional check because of the number of check boxes that they would have to maintain due to multi dimensionality of any calculation module.

     

    Misbah

Categories