Hi experts:
I put all the values into the formula, I think it should return TRUE, not FALSE, but why it return me FALSE? Maybe I missed something here ? Thank you for the help!
This is due to the numeric value you have given in the "Number of month History" line item. The formula is considering 12 , causing the entire expression to be "false" . the issue is happening only with no.12.(reason being the expression needs Future Year)
When you have future years in the model time , then this would works fine , see below SS
Thank you for the help, yes, because I applied Time range here and as no future years , the formula return FALSE, I have already updated time range start Period, now it works!
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New β New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, noβ¦
Why in my model output is blank, after send explainability data.
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Rankingβ¦
