Register
Ask the Community

About cianna.bramley

since ‎09-05-2017
‎04-07-2022
cianna.bramley
Contributor
Activity Feed for cianna.bramley

Re: How to "do nothing"?

by Contributor in Anaplan Platform
‎01-08-2020 10:15 AM
‎01-08-2020 10:15 AM
Hey, yeah I'm afraid you can't reference a line item in its own formula, it's circular referencing which can't be done in Anaplan. You need another line item if you want to manipulate the data 🙂 ... View more

Re: How to "do nothing"?

by Contributor in Anaplan Platform
‎01-08-2020 09:46 AM
‎01-08-2020 09:46 AM
Create a new line item for this! For example, say the original line item is A and the "action" taken if condition is met is to multiply it by 50 B= IF [condition] THEN A*50 ELSE A ... View more

Re: The Anaplan Way - Badges

by Contributor in Anaplan Platform
‎05-13-2019 09:26 AM
2 Kudos
‎05-13-2019 09:26 AM
2 Kudos
@ramjeegupta02 Ramjee,   I found this for you: If you believe that your account is missing specific permissions or designations, such as the Partner label (for Anaplan Partners) or The Anaplan Way Certified badge (for completing The Anaplan Way training), please contact community@anaplan.com .   https://community.anaplan.com/t5/Community-FAQs/Register-for-the-Anaplan-Community/ta-p/38792 ... View more

Re: The Anaplan Way - Badges

by Contributor in Anaplan Platform
‎05-13-2019 09:09 AM
‎05-13-2019 09:09 AM
Hey Ramjee,   I believe your instructor [for the AW course] requests that   the   community page adds   the   badge to your individual profiles, once you've completed your course. If you completed it recently you may have to wait a few days before seeing the badge appear on your profile! If you completed the course a while ago, you might want to contact your instructor or support?   Hope this helps! Cianna ... View more

Re: The Life-Changing Magic of Tidying Up Your Ana...

by Contributor in Blog
‎05-07-2019 10:50 AM
3 Kudos
‎05-07-2019 10:50 AM
3 Kudos
Love this, Frankie!! I'd also add that removing Summaries where possible (from line items that aren't user facing; eg. aren't referenced further and are in modules that aren't featured in a Dashboard) can greatly help reduce your model size! Plus it avoids aggregating over unnecessary dimensions - reducing calculation volume and increasing performance (especially where there are many levels to a hierarchy or many time periods to aggregate over). ... View more

"Select All" for selective access

by Contributor in Idea Exchange
‎02-26-2019 03:48 AM
‎02-26-2019 03:48 AM
When you have several items at the top hierarchy to select in User Selective Access it can take some time (esp if there are 20+ items). It would be nice to have some way to "select all" to save time. (Then if you don't need all items you can remove them quite easily). ... View more
See more ideas labeled with:

Re: Comparing TEXT values

by Contributor in Anaplan Platform
‎10-25-2018 07:13 AM
2 Kudos
‎10-25-2018 07:13 AM
2 Kudos
Hey!   I've included 2 screenshots here of different ways you could do this - whether you'd prefer a written text error or more a more visual "red box" error. (You can see the formula for each in the top of the screenshot - and the second also uses conditional formatting to highlight the "red" cells, alternatively you can use a boolean when checking if it's unique, instead of 1's and 0's!) One thing to note with this solution is that it won't bring back an error for the first occurence of the text (unlike in your screenshot), only the repeated text inputs. I'm not sure if you'd need it for the first occurrence too? Hope this helps! Cianna ... View more

Re: PREVIOUSVERSION(Data) not showing prior foreca...

by Contributor in Anaplan Platform
‎10-15-2018 04:52 AM
1 Kudo
‎10-15-2018 04:52 AM
1 Kudo
Hey Ricardo,   If you check the versions tab then your version should have a "Switchover" of Jun 18, this is why you'll be seeing values of 0 in May 18 🙂   Hope this helps! Cianna ... View more

Re: How can you "Paste Link" in Anaplan

by Contributor in Anaplan Platform
‎09-03-2018 10:26 AM
‎09-03-2018 10:26 AM
Hi,   If you're wanting to 'copy' links from one module to another, an easy way to do this is to reference the line item in module X in module Y's formula (ie. the formula will read Module X. TO PAY (SAR)). This will copy across the links (making sure Module Y's line item has a TEXT-LINK format) and then you can delete the formula afterwards, the links will still be within the cells. KR, Cianna ... View more

Re: Count the number of sparse cells in the MODEL

by Contributor in Anaplan Platform
‎07-02-2018 06:16 AM
‎07-02-2018 06:16 AM
Hey Mikhil,   In terms of sparsity of individual line items, you could add a new line item that checks if the values are 0/BLANK and then return a 1 or 0, then essentially add up the '1's to see how many sparse cells there are in a line item (and you can compare this value to the total cell count of the line item). For an entire model however this may be a little time-consuming..! Cianna ... View more

Re: Can't Complete Course 303 (and quiz error)

by Contributor in Academy & Training
‎09-19-2017 09:03 AM
1 Kudo
‎09-19-2017 09:03 AM
1 Kudo
@ChrisMullen I was using Chrome, and thank you! 🙂 ... View more

Can't Complete Course 303 (and quiz error)

by Contributor in Academy & Training
‎09-11-2017 06:56 AM
‎09-11-2017 06:56 AM
I passed the quiz on course 303, but the button to go to the next slide was unresponsive. I quit the course hoping that, as the quiz was completed, a tick would appear next to it.. but no luck! When I went back in (selecting to resume at the slide I finished on) it brought me to a page saying that I only achieved 10% and had to retake quiz. I did so, again achieving pass marks, managed to get to the next page but no further.. Quit again, no tick in box again, went in again, "your score: 10%".. Tried a THIRD time with 100% in the quiz and same thing happened again!   Please help! 🙂 (screenshots attached) ... View more
Labels:
My Accepted Solutions
View All