About cianna.bramley

cianna.bramley

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 🙂

cianna.bramley

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

cianna.bramley · ‎05-13-2019

@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

cianna.bramley · ‎05-13-2019

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

cianna.bramley · ‎05-07-2019

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).

cianna.bramley · ‎02-26-2019

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).

cianna.bramley · ‎10-25-2018

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

cianna.bramley · ‎10-15-2018

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

cianna.bramley · ‎09-03-2018

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

cianna.bramley · ‎07-02-2018

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

cianna.bramley · ‎09-19-2017

@ChrisMullen I was using Chrome, and thank you! 🙂

cianna.bramley · ‎09-11-2017

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)

About cianna.bramley

Re: How to "do nothing"?

Re: How to "do nothing"?

Re: The Anaplan Way - Badges

Re: The Anaplan Way - Badges

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

"Select All" for selective access

Re: Comparing TEXT values

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

Re: How can you "Paste Link" in Anaplan

Re: Count the number of sparse cells in the MODEL

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

Can't Complete Course 303 (and quiz error)

Re: Comparing TEXT values

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

Re: The Anaplan Way - Badges

Re: Comparing TEXT values

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

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

Re: The Anaplan Way - Badges

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

Re: Comparing TEXT values

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

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

Re: The Anaplan Way - Badges

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

Re: Comparing TEXT values

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

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

So long and thanks for all the fish!

Allow Time Ranges to move dynamically in relation ...

New Function To Convert Date Format to Text Format

Audit request - applying filters to history export...

Actions to be made context aware