
Calculation Functions
Calculation Functions
Discussion List
- Hii Community, Here, Source module contains Employees Dimension, Department and Country as List formatted Line Items and Bonus as Boolean format Line Item as shown below. Target module contains Countr…
- Whilst the current method for formula scope encompasses the existing options (Actual, All Versions, All Versions Except Actual and Current), there is sometimes a need for formula scope to be applicabl…
- 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] After applying this i am not getting data populated in shipping time week line ite…
- Hi , i would like to copy the data from sept 2020 to jan2021 -dec,2021 for Budget version and take May,2021 data and copy to Jun,2021 -Dec, 2021 for forecast version. Any suggestions to achieve this.S…
- I have a module without time dimension but there is a column with the sales revenue date. My formula for PY_ar date is just the ar_date minus 365. Can I leverage these two to get PY Sales revenue for …
- When changing the model calendar or available time ranges beware of the unintended consequence on any PERIOD functions in your model. Here are the details on what caused a phantom issue at a customer …
- hi Community, I just got this requirement recently and it is giving me quite a challenge. the requirement is to select the current month then display the 3 prior months and Current month on the table.…
- I have a large model that is used to generate a business forecast. Each time we need to generate a new forecast or scenario, a new version is added so that the inputs can be changed and the outputs th…
- Hi! I have a module dimensionalized by a list of unique identifiers that is the child of a Location list. I'm trying to rank survey dates (a date formatted line item) in descending order based off of …
- It would be great to have "Hold and Release" functionality extended to NUX as well. Break back seems to be working fine with NUX but sad to see missing hold and release functionality. Hope this featur…
- If we use the the MONTH function to convert a month - for example "Jan 15" which is month formatted to Number, the outcome is "1" and not "01" My requirement is to turn "Jan 15" as 201501. So I wanted…
- Anaplan allows users to paste text from dirty sources like Word which includes nasty characters like CR/LR, smart quotes, em/en dashes, etc. These invariably cause problems when exporting data from An…
- Hi Anaplanners, I am trying to model a queue building up in Anaplan and I am wondering if there is any way I can use the Lag function to return the adjacent value without time dimensions. The principl…
- Hello, I'm in the process of building the module for user story 1.11 and I am struggling to get the correct formula. I need to convert yearly data to quarterly data using the SYS99 Time Settings modul…
- Hi @JaredDolich @Misbah , How are you? I completed the User Story 1.11. But I have a question. When I select All Account, the % of Account Sales Target aggregate automatically. Any help would be appre…
- I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020. The formulas I am using in REP04 are producing numbers, but they are inc…
- Is there any way to turn off this feature? I often just want add a simple correction to a formula, hit enter and move on. Instead of just the minor edit when I hit enter to close the formula editing i…
- I want to Find combination of List. I have relationship of Customer-Product and Product-Supplier. Then I want to find combination of Customer-Supplier. Now I don't want to make Lineitem which has "Cus…
- Hi, I need help on creating a condition where if one LI is lesser than another LI, then my intra-month growth amount must be less than my write off amount. Not sure how I can make this condition happe…
- Hi, I have a requirement where in if user selects a Boolean(Show Ending Balances) then it should show only ending balances (which is a top level for L1 description types of list) along with Ending Bal…
- Assume the following Non-Composite list, ragged hierarchy, needs to be set to Production Data. We need to refer to the ultimate parent to define the logic calculation. In the example, we have assumed …
- This is an extension of already requested options to select multiple items in a UX context selector (for reference, see that Idea here and here). I wanted to call out the specific request that it be p…
- How Can I add filter by country and filter by segment in this: Accounts are dependent dropdown set up on country. Thanks -Pooja
- Hi team i have an issue with the country summary module In country summary, stock safety flag i have given a formula but its not showung Sku list in the module, and if inv01 safety count flag should b…
- Hi Everyone, I'm fairly new to Anaplan and currently self studying so please bear with me if this question seem basic. Is there a way for me to use a boolean formatted line item to serve as a basis t…
- When searching for FVSchedule in Anaplan Community there was seemingly method for/content about this. There are always multiple methods to achieve the same result but this method has provided the requ…
- There is a need for Anaplan to have standard Iterative Calculation Functionality. The model that I’m building for the client includes multiple circular references. I need to calculate the amount of th…
- In '3.3.5.3 Check Your Work' Level 2 Model Building : Sprint 3, I succeeded on comparing the INV01 module that I've made with the first and second example above (on SKU level) without changing the su…
- @Misbah Could you tell me what I am doing wrong in this formula. Demand = 'DEM03 Demand Forecast'.Final Forecast[LOOKUP: 'SYS08 SKU Details'.Product]
- Hi , As per the screen shot, in the left grid whenever i select the y the the left grid should show the same year start month and end month and if i select the y-1 ans week 44 the value then the right…