-
How to remove text before the dash (-) sign
Hi, I have a line item where I need to remove all those before the dash (-). Is there a way to do this? currentexpectedXXX - 123123XX - 12341234 Thanks!
-
Using Delete from List using selection for partial deletion of data for current Month only!!
Dear Community, Needed to check whether is it possible to delete Monthly data using Delete from List using selection for that particular current month. For example if we have data from Jan 2022 to Apr 2022 but we need to delete only the data for month of Apr 2022. How can this action be modified since we can currently…
-
Actions working differently in different environments
I have an Process which contains 4 actions. This Process is in DEV, Test and production environment. The process works well in Prod but not in DEV and Test for the end user. No change was made with respect to the actions in DEV. Also tried setting model same as end user's role. But still its throwing error in Test and dev.…
-
About textlist Formula
Hi I want to Textlist function. I want to get Customers by Product List. But I don't know how to use it. ListLineitemProductCustomerConbinationTextListP1C1☑C1,C2 C2☑C1,C2 C3 P2C1☑C1,C3 C2 C3☑ Do you have any idea?
-
Get dates in different dimensions module
Hi, I have a requirement to pull the dates in the module, the source and the target has different dimensions. Target module Source module I want the dates basis on the revolver in the target since I can't use sum function on the dates to pull it any workaround for this use case.
-
Get a total value on other line item
Hi, Can you help me with the next item. I need get the total value of the line item "%" and put in the line item "Pond". in the line item "Pond" is using a LOOKUP but a cant see any value.
-
Get Average of two month on same line item when is Budget
Hi , I want just calculate the moving average for the last two months, however once use the following formula IF ISACTUALVERSION() THEN Revenue actual ELSE movingsum(Average Revenue,-2,0, AVERAGE) Then circular reference error shows up. Could guys give me hand on how can solve these issues? I am looking forward to your…
-
Hierarchy
Hi Team I am having an hierarchal list (Product L1,L2,L3,L4,L5). I am having a module which is having Product L5 list as dimension. I have published the above module to the dashboard and also published Product L4 list as page selector and synchronized. If user having access to all the hierarchy and user can select any…
-
SELECT AND LOOKUP
Hello Community, anybody to help me, I'm trying to pull data from Module which has Time,Version,Lis as List and Amount as line item in Target module which does not have time and version means it has (Lis and amount as dimension) I'm trying to avoid hard coding {Source Li[SELECT:VERSIONS.ACTUAL,LOOKUP:GLOBAL DRIVE.FY]}.…
-
Lookup by roles and employees & country
Hi guys, As you see in capture 1 we have the Role wise salary details , but i a not able to get these salaries by employee wise , please look capture 3 sys module is there anything i am missing to get releation please help in that to get the employee wise details
-
User Selected YTD Time Filter
Hi everyone, Currently have a developed user-selected time filter we use on all of our UX Pages. Driving module: Page/Board Filter: We just implemented the YTD summary yesterday and now I am struggling to get some sort of filter in place where I can check a box and it appears similar to how months, quarters, and years work…
-
MROUND showing inconsistent results
Hi, I am trying to use MROUND formula to round to the nearest 100. However, there is some inconsistency that I spotted. original number * multiplier = number to round Example 1: Example 2: Why are the output number different when the "number to round" is the same? I want it to round to the nearest 100. If there number is…
-
Previous Function Cut-Off Date
Hello, I have a formula written that takes "Company Churn" / "Previous Revenue" Previous revenue = PREVIOUS(Revenue) The formula works for the individual months, but when it does the summary the rates are incorrect because it always has one month more worth of data in the revenue line item. Is there a way to say "If the…
-
Ratio Summary - Line item & time.
Hello Team, I was wondering that can we have different ratio for line items and time. For ratio as summary in Anaplan we have only one option, which will calculate the same for both line items and Time. Any suggestions, can we have different summaries by any work around. Thanks, Manjunath
-
Formula to end time
Hi I have this formula that will add 1(digit) to the months following the current start month however I would like it to stop adding number after month 23. I can't figure out how to end the argument/formula so it stops adding number. Ex: Current month is 0, Next month is 1, following month is 2 etc, last month should be…
-
How to create a loop formula
Hi everyone, I am stuck on a formula. I have demands for 2021 and I need to calculate the demand forecast until 2030 by using the formula below Demand 2022= Demand 2021*Growth rate 2022 Demand 2023= Demand 2022*Growth rate 2023 . . . So how can I do that? Thank you!
-
Quarter Apportionment
Hi Team, I have couple of queries regarding the below snapshot * Both Q1 & Q2 has 91 days, however the quarter balance is different? Can anyone explain the difference? * Are we calculating values for quarters first, & then segregating the quarterly values into monthly or is the other way around? * What does "Quarter…
-
Quarter calculation
Hi Team, Can anyone explain me this calculation? This calculation amounts to 102% instead of 100% As per my understanding, it should be 31/90 = 34% 28/90 = 21% 31/90 = 34% Still, I'm short by 1%. Can anyone explain Also, can anyone confirm what is "Quarter Apportionment"? Is it no. of days by each quarter? 2022 Even as per…
-
Time dimension formula
Source Module has Year, Target module has Months. Source - Time dimension (YEAR), Cost center dimension, Line Item Target - Time dimension (Months), Cost Center dimension, Line item Source has rate by year, for example for FY23, Want to bring FY23 rates to all the months in target module. What formula would i use in terms…
-
How to calculate the total amount without using Select function
Hi All, I have created a module with two list (Company list: A,B,C) and Fruit list (Apple, Orange, Pineapple) Let say company A and C are tier 1 and company B is tier 2 And then i have created another module without any list dimension but just only a line item, how can i calculate the total amount of Apple selling by tier…