-
Re: Performance Comparison - YEARVALUE(x) vs x[LOOKUP: FY]
Yes! Formulas like YEARTODATE are designed to work in a very specific way, in essence they know what dimensions they're going to operate on and how they're going to calculate on that dimens…5 -
Re: Display Status (Pending, In-Progress, Complete) in a Dashboard
I would do this with a LOOKUP to a system module... Create a Status list: Then a system module dimensioned by that list: Then lookup based on that Status:3 -
Re: Using List Properties
Our reasoning comes mainly from the desire to create better and more maintainable models with PLANS - This Is How We Model A good naming convention and clear layout/structuring of modules helps reinf…3 -
Re: Map Setup
Not directly the map chart can only show one value at a time, but you could use a line item subset to change the value. I mocked up an example... Here's the original line items, create a LISS th…3 -
Re: How to calculate the cumulative value without using the CUMULATE function
You're right that RANKCUMULATE does have performance impact. It is a function that has to run single-threaded, most other Anaplan functions can the benefit of splitting calculations over multipl…3

