what Conditional formatting logic to be applied to only highlight highest valued cell and lowest valued cell in a given line item?
@salil16
Will need to know more information about the module and the list(s) involved to help further. Do the lists have a Top Level defined?
Hi @rob_marshall , thanks for getting back. So the list involved wont be having a top level defined
If that is the case, then you will need an additional module to get the overall MAX and MIN (would be much easier if you had a top level member).
Can you tell me more about the module, lists involved, Time, Versions?
And will you have negative numbers or zero values? Those add an extra level of complication because of the limitations of conditional formatting and lack of dynamic values…
Hi @MarkWarren ..no..it will have non negative integers only
Can you please let us know the other dimensions/lists in the module and what they look like (top level members on any of them)?
well, if there are no negative numbers, here's a way to do it using a 'dummy' item to aggregate on. Create a list with only 1 item, this is the dummy. Being only 1 item means we do not increase the cell count when we dimension by it. Here's the line item set up:
We're intentionally ignoring blanks, we want the non-zero minimum number and it helps with the conditional formatting:
This produces:
This mostly works - if you have numbers lower than 1, like 0.5, you'll need to set the conditional formatting minimum to that; or just use something like -0.000001. I'm sure this could be improved upon and hopefully someone better than me will show that! 😆
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue For versions 1.6, 1.7 and 1.8 of the PowerPoint Add-in elevated privileges are required to install the add-in through command line and for the "all users" option. Workaround * Installing through…
