
Calculation Functions
Calculation Functions
Discussion List
- Hi, Please see details on the attachment. My apologies for not posting it on the message box I document my inquiries on my pc for future references. Regards,
- Hi: Apologies for the simple question but we are new at this!!! I need to work out how to work out the % of a item in a line. Using an excel equation it will be sometime like - a2/sum(a2:a5) I am sure…
- Hi, My model's Model Calendar - Calendar Type is set to 'Weeks: General'. I have a module with a column of dates and the Format is set to Week. In another column with Format set to Date, I'd like to w…
- Hi, Please see attachment for details. Regards,
- Hi all, I have a model with the three lists; Cities_L3 which rolls-up to Countries_L2 which rolls-up to Markets_L1. In module I am calculating amounts at the city level using FX rates which are differ…
- Hi, I have a module where I have time as dimension, as well as a list of equipment. The module is on daily level and has a value of either 1 or 0 depending on if the equipment is in service or not. Th…
- Hi all, I just want to share a simple table as a summary of the functions needed to convert data across formats in Anaplan. Is not a big deal, but I hope it comes in handy to some of you. * Transform …
- I would like to see a formula similar to parent but "inverted". When I have an unbalanced hierarchy and need a parent a similar level I would like to choose level from the top instead. example: invpar…
- Hi team, I have a Currency list that has no parent/top item & an input module whereby the user will enter the data into the Currency dimension. In a secondary module I want to convert all those curren…
- Cee-Cee shop module is where my Spool & Cages incoming, Outgoing happens In Cee-Cee shop module i have Expected Cee-Cee return date which is nothing but (Date + Lead time days) Now in Expected Repair …
- Hi all, I thought I'd just summarise some of my learning experiences with summing data using Generic Weeks, since I couldn't find an article that brought this all together. First up, as you will proba…
- Hi, I was going through a best practice video which mentioned that the order of lists in the module can help improve the performance if the lists are ordered similar to their order in General Lists se…
- Hi guys, Assuming I have a concatenated strings with different length but with the same separator.. To illustrate: I have company code+ledger+asset code but with "-" in between.. This 3 do not have th…
- Hi All, I need some advice/guidance. I'm building a tiny model that looks at the number of components used in products. We have one component that can be used in 5/6 products. The end result that I'm …
- Assume, I have the following line items using which I am trying to build a prediction/forecast for "Revenue". Revenue --> Actuals are imported for the actuals period, and this should be the forecast f…
- Hi Team, I'm attempting to create a Period on Period % movement in a module using multiple dimensions but I require the summary level/top level to still calculate using the formula rather than Summing…
- Hi Team, I'm trying to extract the FY from a date. In our world the Fiscal years run from July to June & hence 1/07/19 would be FY20 I could convert the date to a Time Period & have a separate module …
- Hi All, I was wondering if there is a syntax that gives me the first date of my historical years, based on the timescale settings. My Fiscal Year (currently) goes from 01-06-2018 to 31-05-2019 and I h…
- Hi, I have two line items - Year and January - with no dimensions. Year is time period (year) formatted and a user selection January is time period (month) formatted and I am looking for a formula whi…
- Hi All, I want to truncate the decimals from a number like below but do not want to round it. 2.22939393 -> 2.229 2.22977777 -> 2.229 2.59999 -> 2.5 instead of 2.6
- I want to practise formulas and want some deep understanding
- We currently have the functionality to retrieve the values from the Current Version using CURRENTVERSION() Please can we have ACTUALVERSION() to do the same for the Actual Version This provides consis…
- I want to present a dashboard where the information displayed varies depending on the year/version the end user selects - see attached picture of example. The modules that lie behind this example woul…
- Hi, I need to do a lookup in my line items so that I can import the data into a module. I have a flat hierarchy factory list. I have 2 line items Inbound Qty and Lot Numbers. I've split them so that I…
- Hi, In the constraints we specify for optimizer, the last constraint has the format of a - b =0, why is a=b not possible in the constraints. If we change the format , the process will be incomplete. W…
- Hi, I have a module a with several line items. Line item 1 of this module is boolean formated and applies only to VERSIONS. Means, a User has to mark the check box of the VERSION, he wants to use for …
- Hi Team, I have noticed that when referencing a module that has Time as a dimension from a module that does not have it as a dimension that the formula will not return the highest node in the Time Dim…
- Hi everyone, I thought I'd share a something useful I recently discovered, which I haven't seen documented anywhere. According Anapedia, Drilll to Transaction is only supported for formulas like Trans…
- Hi, I have two modules named A and B. In module A, my time range is FY17 & FY18. And in my module B, the time range is FY18 & FY19. The fiscal year in my model is Jan to Dec. Now I want to refer the d…
- Hi Team, I'm trying create some logic whereby I classify each Customer Account as either Existing, New Business or Churned for each Financial Year based on whether they had revenue in the last month o…