
Calculation Functions
Calculation Functions
Discussion List
- 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…
- I got confused between these functions. It's unclear for me now. If any one can help me with simplifying this it would be very helpful for me. Is there use cases where Lag and Lead should be used inst…
- Hi All, We currently have a "Positions" module that is not time based. We show our current salaries, job titles, etc. that comes from our payroll data here. This "Positions" module also contains the E…
- Hi all, I have problems aggregating values from a module dimensioned with day, to a module dimensioned with month. I am doing rent calculations in a module by DAY time scale. When I try to aggregate t…