Options for Override

SBenth79
SBenth79
in Modeling

Hi

I have a module of manually entered data that needs to be reviewed and adjusted by an end user.

The values often need to be overridden and there is a high possibility of the overridden value being zero. Also the overridden data will often be copied and re-used within the module across different dimensions

What options are available for overriding these values?

I have come up with the following:

  1. An Override? Boolean which is used to indicate that the overridden value should be used in place of the original value
  2. An If Then Else statement to check if the value has been overriden and if not the original value will be used (not ideal as the values are often zero)
  3. A combination of the two options above where a boolean checks if the adjusted value is greater than zero but with an additional boolean to override if zero is required.

All of these options have pros and cons and I am wondering if I am missing any other options that might be better

Can anyone suggest any alternatives please?

Thanks in advance

Stacey

Best Answer

  • rob_marshall
    rob_marshall
    Answer ✓

    @SBenth79

    I believe the combination of a Boolean and a Final Amount (which includes the IF THEN statement) would be best.

Answers

Categories