You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

@ISMBR and @CURRMBR not working as expected

edited Sep 20, 2019 8:29AM in Financial Consolidation and Close 6 comments

Summary

@ISMBR and @CURRMBR not working as expected

Content

Hello,

I need to perform a calculation with an "On Demand Rule" only for the "Forecast" scenario. Since I cannot fix the Scenario dimension, I'm trying to include the calculation inside a condition, but this is what I get:

1. Using @CURRMBR: IF (@CURRMBR(Scenario)=="Forecast") --> The calculation is performed ALWAYS, no matter what Scenario is in the POV.

2. Using @ISMBR: IF (@ISMBR("Forecast")) --> The calculation is NEVER performed, no matter what Scenario is in the POV.

I have tested a lot of different combinations, but the outcome is always the same (never or always goes into the condition)... Am I doing anything wrong?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!