Hi Friends, I have a list of Fruits and the month that is sold. Now someone has entered the month in TEXT format 1,2,3,..., 11,12. I want it to be Jan, Feb, Mar,...,Nov, Dec. Writing IF-ELSE is a tedi…
Thanks community friends for your kind help. I am stuck in a step. Need your suggestions. I don't want the percentage to add up but remain the same (ie 5%).
I need help creating a list for the market. I was able to do this at the retailer level, but how do you do the same thing for the market. I need to be able to do this so that I have the code for the m…
Please add the feature to enable line items and data with free text, with all characters including line feeds. Ctrl+Alt+Enter creates a line feed while entering the data, but it is lost when the data …
Hey Experts! Hope ya'll are doing well with everything happening around:) So there is this requirement where we require to bring in a list of selections into one single cell. My immediate thought was …
Hi, I have an issue regarding how to set up a formula to get a calculation to work. I have a mapping module, where you can enter how a specific calculation should be done, looking like below: DriverCo…
Hi , I need help in the below query, I have a boolean formatted line item in source module published on a dashboard. As soon as the Boolean flag is marked “True” by ‘Role A or Role B’, the expectation…
Hi, I have a module with no time dimension.In this module I have a line item "Contract Amount". In another module that has time dimension, I also have a line item "Contract Amount". In Jan 2020, value…
Hi,everyone. Can I set a default value for a list? I have a list of calendars. For example, if the current date is February 1, 2020, I would like to display February 2020 in advance. Best regards. Tak…
I have 2 modules: Data Module and Dashboard module. 1. Data Module has: Region (List Item) Product (Line Item with List Items called PRODS) Value (Line Item) Export? (Line Item - Boolean) e.g North Am…
Hi, I have a line item in percentage (POC). I already created the formula and set the summary totals to formula to get the correct %. But I need the value of the percentage for the following year. for…
Hi All, Hope you are doing great! I have to create a peculiar way to calculate weeks and then calculate the days in each of these weeks. Please find below the rules to create a week- * Weeks will be d…
Hi, Curious to know if I enter the formula at the line item directly, would it work (screenshot)? Im doing LM1, reccommneded method is to double click and write on top or expand the formula bar. But l…
Hi CODE(ITEM('G3 Location')) and PARENT(ITEM('G3 Location')) were defined for the following Code and Country results. Is there a 'grandparent' function that can be used to display Region?
Hi, I am trying to differentiate between a 'null' value versus an actual true zero (- vs 0) on a dashboard. Has anyone had any experience with this? I am looking at formula options to resolve this iss…
Hello everybody! I've come across a problem with making accurate calculations for a line item in currency/unit for previous year. My model has system version called "current" which has 5 years (2019-2…
Hello, I am currently running into an issue with one of my models where historical plans are changing due to actual restatements. I have a model with 4 versions. Actual, Budget, Working, and Current F…
Hi, I need to be able to display the page selector value in a column. The purpose of the module is to assign multiple positions to an order. If it had been the other way around (assign an order to pos…
Hi All, I noticed recently that the drill down ability on percentage formatted line items has been limited to the amount of decimal places / minimum significant digits selected for the format. Further…
Hi everyone. I would like to set search conditions for each user and I want to filter and display data. There are 110,000 items of data I want to display, and I want to specify search conditions for e…
This is the module I have. Now for the output is it possible to get the report of the module edited into the below view without editing the list name. I have no restrictions to create a new module or …
In the attached example, I am using a rank function in the RANK line item to identify rows with non-blank ICM_ASNMT_ID and assigning them ascending rank values. Next, I want the MAX RANK VALUE line it…
hi I have 2 dimensions, one is Dates and one is accounts, and I want to return the first date for each different account where an amount occurs and on future line in that account How do i do this? the…
Hi, Is there anyway to have a boolean formatted line item = True if it is a parent line item? Example: Line Item A - Applies to: L1 - Format: Boolean - Summary: Formula L2 is the parent list to L1 How…
Hi Friends, I am having the data in this format. I tried it in excel but I am getting the output in the below format. Even making States as List Formatted Line Item didn't work. By any chance can we g…
