Hi all. i want to achieve the formula with raised to the power of. I have this formula in excel which is =(S12/(1+($E$14/12))^(P12-1)) now how can i convert into anaplan formula? this is what i've got…
Hi Anaplan Community, I am trying to export data from Anaplan into Power BI using the Anaplan Connector. I manage to get my values into PBI, however, I miss the decimals precision which I see in Anapl…
Hi I have 2 Lists and 3 modules as shown below. I want to build module 4 (details below) in the most efficient manner. Seeking ideas. Thanks in advance List: Employee ssL0Employee ssL1Employee ssL2Emp…
I've built an import and mapping logic to bring my actual data into my Anaplan model and everything is correct on the line item "Actual Expenses" as shown below. However, when I run an import action t…
I am counting the project item(List: Project name) based and generating a unique number by adding +1 to count . everything is working fine until a situation comes where i have to delete some existing …
Hi Anaplan community, I wanted to make a quick fix to existing formula in my Anaplan blueprint view, so I exported my blueprint view to Excel, used the find&replace functionality in excel to update al…
Hello, The IT team of a client has built a integration with the data base to Anaplan using the API. They have a problem of Authentication when Anaplan ask to reset the password, giving a 401 unauthori…
Hello all I have a question regarding the New Anaplan workflow . In the online course provided by Anaplan it says when a Decision Task is created and assigned for example to a user , when workflow sta…
Hi All, I have come across a weird scenario where cell history of a Boolean formatted line item is not getting captured properly. For e.g. : In the attached snippet of a cell history of a module below…
Hi All, I'm currently facing two issues related to import. I have one module (split in three tables in UX) in which the user imports data. Here's the module: The import action works perfectly well for…
how can i lookup the currency rate based on filter that i selected in REP01 Long Term Loan Payable. General List: LO05 Currency Module: SYS03 Foreign Exchange Module: REP01 Long Term Loan Payable
Hi. In one of our modules, are current pivot set up is: Pages: Version Rows: Line Items However, we need to add a list '# Customer' into Pages, to get the below pivot view: Pages: Version, #Customer R…
For example, Module A has SKU list and line item POS which has certain data in it. Need to reorder the SKU list with respect to POS line item data in descending order (Highest to lowest). Used Order l…
So in the current setup, a module is dimensioned by Model- calendar time dimension and the horzion is from 2021 to 2026, the granularity being weeks. This setup is used in prod since go live for 2 yea…
Hi, I have created a numbered list (# Customer Number) successfully (with no parent, code as customer code, and name as customer code name). I'm trying to now create a numbered list as a child of cust…
Hi All, I am try to query the presence of a list item in a source mapping where the source contains TIME dimension. Source contains one list combined with TIME where a mapping can differ across a year…
Hi everyone. what is the formula on adding a number sequent in one column like 1,2,3,4,5 etc. i tried RANKCUMULATE but it returns all 1. by the way this result was already filtered. thank you.