
Calculation Functions
Calculation Functions
Discussion List
- Hi, Can anyone please suggest to me what is the mistake I'm making here? Q:
- Note: please send Kudos to this post to get it on the roadmap. Please can either model builders or end users have the option to toggle the summary method used on lists where it is possible to view the…
- Hi getting below message when I try to add formula to code as per 6.8.2 Activity .
- I have a source module dimensioned by tmpSalesTerritory list, that is a numbered list Need to get “final_segment_country” and put it in this module below on yellow marked The problem is when I lookup…
- Hi Team, I'm using the FIND function for the 1st time & it not working as I expected. It seems like a basic Function so I must be missing something easy but I would assume that below the value returne…
- Hi there, I need to reference a source module line item with time to a target module line item without time to achieve an Actuals Rolling [6, 12, 28, 24 months] SUM using MOVINGSUM. In this case, it w…
- I input formula Growth%= MONTHVALUE('DEM01 Volume Growth Rates'.Growth %). Timescale has been set to week. Summary is None. View on DEMO 2 shows zero. attached screenshots. Am I in the correct directi…
- How can i pull a data from a module with time dimension to target module with no time dimension using a finditem mapping made in the source data? To illustrate, my total sales of 1,000,000 was divided…
- Hello everyone. there is a small question - the forecast demand field in my model is different from the screenshots in the tutorial. Was it me wrong in the formula? baseline forecast formula: IF NOT '…
- I'm trying to find the reason why my number for Final Forecast (for All Accounts) in Week 3 FY20 does not match Initial Demand Forecast number. I attached the screenshot from the page.
- The profile function is great when you want to calculate data from a start month for future periods, it would be great if it would also work to profile data going back in time from the start month
- It would be good for the PROFILE function to have the option to work going backwards as well as forward in time,
- Hi, I want to do like this table "temp2" Lineitem searches the days from now to next temp1. Time2022/1/12022/1/22022/1/32022/1/42022/1/5 temp1 ☑ ☑☑temp213211・・・ Is there any function like this?
- Good evening! Please see my screen shot below. The training asks us to do the following: Create a new saved view: * Filter: Forecast Months only * Saved and name the view: Forecast Periods My apologie…
- Hi Everyone., I have a module that is dimensioned by Product List. Two line items are added, one is Product List formatted, while the other is text formatted(this is not dimensioned by Product). Produ…
- Hi, We are currently have a module that is dimensioned by a list of dates. Trying to figure out what is the best formula to use to bring List data in as a date for a LI.
- HI Community -- I have a column (text) that returns either a value off 1 or 0 . but I want to create a column that actually creates the corresponding value . For instance is the value is 1 then its Di…
- Hi, I'm trying to check if all the info are correctly filled in , I mean the line items used (format as list) are correct? I used ISBLANK function, but seems it's not correct when I'm changing the cur…
- I have been struggling with my formulas and I just wanted to check that my Forecast cf formula was correct. It worked the first time which made me nervous. The instructions are: * If Initial Demand Fo…
- Hello, Which formula should I use in order to bring the correct Currency based on the Company Code? I try with FINDITEM and LOOKUP functions, but I guess I'm doing something wrong, as I have errors. T…
- I am trying to develop calculation formulas for the REP04 Employee Expense Summary, but keep receiving errors and incorrect numbers. I posted each of my attempts with screenshots of formulas and resul…
- Hello all, i am doing level 2 Sprint 2 activity 2.3.9, where i need to use FY 2019 data in order to populate FY20 (ofset formula). My model calendar is at FY 20 while time range is for 2019. but for s…
- My export file seems to have everything okay except for the 3rd number onwards on the first row. And I used this formula IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(E…
- Use case: As a user, I want to display the current time (e.g. 9/12/2018 5:00AM) in a cell. This should behave similar to the "NOW" function in Excel. Business case: When a user presses a button, we wa…
- Hi All, Can Someone help as to how can we Identify number within a Text Formatted Line item and move those numbers to a new line item with number as a format using some formula. E.g. Line item 1: Text…
- My numbers are coming out larger than the given numbers. Lloyd
- We have radio buttons for Site selection on the new UX and I am asked to change that to dropdown list. In order to make the line item a dropdown list, I created the line item with the List format (Sit…
- Hi, I have an input module with a user dimension, published in a DB where End users can enter the inputs. I want a consolidated module where I can view all the entries/data but without user details or…
- I need help I am getting negative numbers for my beginning inventory and the week 1 comes off as a 0. On top of that the "Override Suggested Order Amount?" Boolean is not allowing me enter anything ev…
- Hello, During my training, I had to build the Inventory ordering module for the supply chain model (level 2). After building it following the instruction, I'd like to test new formulas to determine th…