-
formula summary
HI All, Why we use summary as formula. what are the scenarios that we use this ? what is the outcome of it?
-
Rankcumulate - unexpected result
Hi, I am using the rankcumulate function but I am getting some really unusual results, wondering if anyone could assist as I have no idea why this is occurring? I have attached the formulas and also the results. Thanks in advance
-
Moving values from one module to another while Line item is being used as Dimension in other
Hi everyone: Module 1: Dim - Entity (Aus 1, Aus 2....) LI - please refer below as (numbers) Module 2: Dimension: LI of first module , Parent of Entity (Aus..) Line item: Amount (which will have the values from the first module) I am getting same value distributed across all the Dim 2. Can someone help me out in this case…
-
Find an item in chart with 3 conditions
Input Road 1 France Germany Type A Road 2 France Germany Type B Road 3 France Italy Type A Road 4 Italy Germany Type A Question Hello, I would like to know how to get back into a module the correct road. The road depends on three conditions as above. For example, if I am told that the road is France Germany Type B, I would…
-
[Part 2] Using line item subsets for dynamic error messages for user input validation
* Step 1: Create a module for your error messages * Step 2: Create your line item subset * Step 3: Create a System module to store metadata associated with the validations * Step 4: Create a module and use COLLECT to summarize error information * Step 5: Create an Output module to display the error messages and other…
-
Rank Formula || Need to Cumulate in Reverse order
Hi Everyone, I have a module dimensioned by List 1 and Time (Quarter). There is one imported line item (List formatted). I want to number these imported cells data according to the quarter. For example:- List item A has values in the following quarters Q1FY23, Q2FY23, Q4FY23, Q1FY24, Q3FY24 (other quarters are blank) so I…
-
Quick Sum Bar for Maximized Card Views in NUX
Hi, Quick sum currently works for cards on a board, but does not work when a card from that board is maximized. This was a feature in the old UX when a module on a dashboard was maximized. We have a good deal of users asking for this feature.
-
Rank Formula - Excluding Blanks
When looking at the page for the rank formula, there is a callout that says "Remember that if a source value is blank, the blank is ranked first for ascending order and last for descending order.". I am wondering how blanks could be excluded from a rank formula where I need to sequentially rank records based on when they…
-
Break text into new line
Hi Friends, What is the command required to break text into multiple lines in a Dashboard.
-
Move data from fake time period to real time period (For restriction of drop down selection on time)
Hi, I want to move the data from fake week to real week. I tried with multiple formulae and still getting errors. Request your help. Please find the screen shot of requirement below: And I have a mapping module as below: And my fake week list is as below: Note: The reason why I have created a fake time is period is that my…
-
LEVEL 2 - SPRINT 2 - 3.3.5.2
Can I know if the formulas are right and I need help with the other formulas
-
10.2.1 Add non employee expenses module
Hi Community ! 😀 I'm learning the training and I completed everything but the formula is what holding me back for the past 30 minutes.. So below is what I have : & from the training I am suppose to have ... Thanks in Advance for your patience ! @Akhtar.shahbaz
-
10.2.2 Import data into Non employee expenses module
Hi community ! Please bear with me as i have a learning disability. I keep receiving this error message ... I would greatly appreciate the assistance. Thanks in advance ! @Sowjanya @jagadishdash
-
Adding a common line item associated with a single list item
Hello all, Can you please advice how to add "line item associated with a single list items"? In the attached screen shot, •MU approved/agreed and •GS approved are list items and I have created a nested dimension in module, such that the line item is common for these list items. Now I need to add, the columns highlighted in…
-
2.3.10 Activity: Create Demand Forecast- Need Help
I'm not getting any values for my 3 line items after the baseline forecast. I cannot figure out why this is happening. I see growth percentages in my source modules, but they are not being carried over in my formula for my "DEM03 Demand Forecast Module".
-
Create DEM04 Demand Export Module
Hello, please help me define the summary methods of Demand Export Module to match my results with the correct answer from the course. here si my results The correct result is attached
-
Help with formula using IF THEN ELSE statement with Versions
Hi, I'm trying to create a formula where the End User Input will flow to both the Forecast and Budget Version of my model. The formula I'm trying to use is below. I can get the End User Input to show in my Forecast Version, but not my Budget Version. Thank you
-
8.8.2 Activity Add Formulas to Country Margin Report
Hi Community ! 😊 So Im completing the training and Im suppose to have the same page as my screenshot below : But Mines Turned out like this : Some help would be appreciated Thank you in Advance ! @Akhtar.shahbaz Im not sure if I should change it back to sum But i dont think so .
-
DEM 03 Baseline forecast formulas
Hi, I am trying to write formulas for this activity: Here is what I am doing: But the results are nor correct, How should I change the formulas and/or summary methods? Thanks
-
Export action not working properly
I am not getting the export as i selected in saved and drop down
-
Export action not working..
HI All, I have a module there i have saved view for export. when i exporting in module its showing correct data. when i create the action button and run and see the results its diffrerent . please expain the issue.how to rectify it.
-
Put a condition in a lookup
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 you can help me with the formula for "Origin Country". It is supposed to send me the information from the previous step to…
-
Boolean Selection
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 highlighted items for Plan, Actual CY and Actual PY as well. We don't want users to do multiple selection just to cover the…
-
Lesson 9.2.5
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 formula in unit cost % in rev05 it works just fine. I have went back to look at SYS04 and SYS06 formats/formulas and haven't…
-
issue in populating data
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 Settings By Week'.Current Period? THEN 'DAT03 Historic Volumes'.Volumes ELSE 0 Also used IF 'SYS01 Time Settings By…
-
Further help, with what should be a simple lookup
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 images to feed a business report A simple lookup in Excel, looking up 1 ,2,3,4,5 etc but for the life of me i can't figure…
-
Fetching Start Month and End Month for a given Quarter
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 multiple ways and looking for help to fetch Start Month (say for selection of Q1 FY20 - looking to fetch JAN 20 similarly for…
-
Rank using Unique Item
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 MonthChangeRankCustomer A - Product 1340,480311,576-28,9051Customer A - Product 270,32646,326-24,0002Customer D - Product…
-
Level 2 - Sprint 3 - 3.3.5.2
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 Timescale? * Use this Boolean-formatted line item to select the first week of the timescale. * End users can manually select…
-
Level 2 - Sprint 3 - 3.3.5.2
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 Inventory from the previous week. The syntax of the formula should be written: If it is not the first week of the year, then use…