
Calculation Functions
Calculation Functions
Discussion List
- Input: ABCDEFranceGermanySpainPortugalSweden Calculate : BCDEOrigin countryFrance (A)Germany (B)Spain (C)Portugal (D)Actual CountryGermany (B)Spain (C)Portugal (D)Sweden Hello, I would like to know if…
- Hi, Is there a way where I can manipulate the boolean checked by the user and automatically selects as well the other selection? For this example, if a user selects Forecast-Aug, it will deselect the …
- Hi all, I am trying to input the formula in unit price % in rev05. I am getting the error "Dimension of mapping used for lookup doesn't match any dimension of the result". However, when I input the fo…
- Hi Members , I am still facing an issue where in I have to populate FY WEEK 20 forecast with the Actual volumes of FY WEEK 19 ( ALL weeks ) I have used the below mentioned formulae IF 'SYS01 Time Sett…
- Hi, I have a ranking module as below This shows the top customers and some data changes ranked, also there is an image for each customer Now I have a module where I need to store the top 5 customers i…
- Hi all, I'm trying to fetch Start Month of a Quarter input by the User. I created a line item for input by the user formatted as Time Period Quarter and another Line item formatted as Month. I tried m…
- Hi, I have a module which shows change in volumes by Customer - Product (over 5000 lines) I then rank these changes largest to smallest, and have a view of that. Customer ProductLast MonthCurrent Mont…
- Let me know, if what I did is right or not Create a Filter You will need to create two Boolean-formatted line items in the SYS01 Time Settings by Week systems module: * Line Item Name: First Week of T…
- Can I get help regarding this? This line item needs to display the value from the Beginning Inventory line item in DAT01 Beginning Inventory module for the first week of the year and the Ending Invent…
- Hi, colleagues! Do you know any elegant solution for entering weekly subtotals or week ID's into module of model with calendar type month/quarter/year? Cause I faced such issue: FP&A team wants a modu…
- Hi all, I tried to replicate the example in the Anapedia link However, I cannot get the same result as in the example as below. My module as below, my result as highlighted. Even the same cash flow da…
- Why does the formula change when we change the Time Range from CY and PY to Last 5 yrs?
- I can't get the value or in others words add the numbers in the Suggested order amount of the month. The line item always shows 0 no matter how hard I try. You can see my formula on the formula bar. W…
- Hi Team I want to pull a Boolean value from a time dimensioned module to a non time dimensioned module. Source module looks something like Could you please suggest? Thanks
- Hello! I got a Invoices Data Load Module that gets its data from a numbered list "Invoices". The line items (invoice number, client, comment, amount, date etc) are the "Invoices" list properties. We s…
- Having trouble seeing why my check is not coming through for my TAR01 module. Attached are screenshots. Thank you
- I have a RANKCUMULATE function that is working fine but when a negative number is referenced it ignores it rather than subtracting it from the running total. I am hoping someone has run into this befo…
- Can i Use Numbered list Unique identifier as a Part of code for Numbered List?, How long can a Unique Identifier can go? I have a numbered list Named 'Activity List' under a Customer List as its paren…
- Hi, I get the results I want in my Model with the following formula, but in the Exam it is not accepting my formula. Is my Syntax incorrect? IF 'INV01 Inventory Ordering'.Submit Purchase Order Request…
- Hi, I can not get my module to populate. Please advise. Thank you
- Hi Team I need to identify records that have same value in Column 1 but different values in Column 2. For eg, from the below data set, I want to identify the 1st 2 records may be by adding another lin…
- Hey all, I'm wanting to update a time filter to use in module views but am having a hard time figuring out how to create a specific condition. I want to have a filter for the current quarter and the p…
- Hi Everyone, I am trying to design a module for shift input. It should be working in this way. When we enter shift start time and cycle period, that start time will repeat according to cycle period un…
- Hi, My TAR01 Detailed Sales Target is off. I'm not sure why. I tried to pull from D02 Data Module, but then my dimensions were wrong and wouldn't let me look up by product and country. I have been stu…
- IFO is a very crucial formula to use when working with raw data, staged in Data Hub, to create lists from within the data's metadata. It truncates the metadata within its line item to "Its First Occur…
- Hello, I'm stuck on the logic to create a filtered summary view. I have a table A, but now want to create a filtered table B (which is a list of only the cost centers & Worker Type combination with a …
- Is there any formula instead of first occurance
- Hi, I want to use Statistical forecast APP. This app presupposes forecast 1 Month? Some Forecast method only forecast 1 month like Winter's method. I want to forecast 1 year. Is there any setting to c…
- In the description from '5.2 Model Build Specifications', we need to calculate the proportion of a country's total sales revenue by product family each account's product sales contributed. The TAR01 w…