Forum Discussion

AkshayBhatia's avatar
AkshayBhatia
New Contributor
7 months ago

Member Formula

Hi, does anyone have any idea on the functionality of 'Revert to Default Scenario' setting for a scenario type in the member formula? Apparently, when a calc is written in the default scenario, it gets executed for ALL scenario types regardless of whether the revert to default scenario setting is set to True or False. Any help/lead about the use of this setting is appreciated. Thanks!

 

JackLacava 

 

Finance
  • Henning's avatar
    Henning
    7 months ago

    Hi, this setting is only used to override an existing formula in your scenario type selection. I.e. if your formula in the (e.g.) Actual scenario type is empty, the formula under (Default) will be executed regardless of the setting. However, if you have a member formula under the scenario type Actual, this formula will be executed when the setting is set to False. With the formula under Actual and the setting set to True, this will override the existing formula under Actual and use the one under (Default) instead.

    That means that this setting is not meant to be used to not execute the formulas under (Default) for all other scenario types, only to override existing ones. Hence the good practice of assigning the member formulas to a respective scenario type as those would otherwise execute for all scenario types.

  • Henning's avatar
    Henning
    Valued Contributor II
    7 months ago

    Hi, this setting is only used to override an existing formula in your scenario type selection. I.e. if your formula in the (e.g.) Actual scenario type is empty, the formula under (Default) will be executed regardless of the setting. However, if you have a member formula under the scenario type Actual, this formula will be executed when the setting is set to False. With the formula under Actual and the setting set to True, this will override the existing formula under Actual and use the one under (Default) instead.

    That means that this setting is not meant to be used to not execute the formulas under (Default) for all other scenario types, only to override existing ones. Hence the good practice of assigning the member formulas to a respective scenario type as those would otherwise execute for all scenario types.