- - Search the Knowledge Base
Academy
Product Roadmap
Events
Groups

Community
Explore the Community
Questions & Conversations

Questions & Conversations

Got a question about your models? Want to start a discussion? It's here!

657 Topics
1,787 Replies

When you subscribe we will email you when there is a new topic in this category

657 Topics

Recently active

Most replies Most views Newest first

MarieJNewly Minted Pigmenteer

asked in Questions & Conversations

Formula timed out due to dimension list too long

Bonjour, Je suis face à une difficulté et le message d’erreur ‘Formula timed out’ sur mon P&L; J’ai un metric qui calcule mon Budget P&L à partir de plusieurs sources (Revenue, Coût, HR, etc.) ; j’aimerais créer un autre metric reprenant le P&L avec une dimension en plus (une dimension Fournisseur présente uniquement sur les coûts) ; grâce à laquelle je peux voir mes coûts à la granularité fournisseur directement dans le P&L.J’ai donc modifié la structure du metric (en rajoutant la dimension fournisseurs, et modifié la formule avec des ADD sur les autres metrics alimentant cette dernière) ; néanmoins je retombe systématiquement sur un message formula timed out > 3 minutes. Je suppose que c’est lié à ma liste fournisseur (qui est longue) , mais je ne vois pas comment faire pour optimiser la formule ?

891

5 months ago

BenedikteOccasional Observer

asked in Questions & Conversations

Error during formula computation. Some values overflows 10^14

Hi, I have been getting this error message in my formulas, and need some help to solve this, anyone that have knowledge of this error? Thank you very much in advance!Regards,Benedikte

1454

5 months ago

RasagyaNewly Minted Pigmenteer

posted in Questions & Conversations

Pigment to Workday integration (sending data to Workday)

Hi all - we currently have an integration set up to bring in data from Workday to Pigment. We are now looking to explore how we can export data from Pigment back into Workday to create a closed-loop integration. Anyone familiar with this set up? Would love to connect to see how we can set this up. Thanks!

1801

5 months ago

cayleybNewly Minted Pigmenteer

asked in Questions & Conversations

How do I hide empty rows and columns in google sheets export?

When saving views and using the Pigment Connector to export them to google sheets, I’m unable to retain the “hide empty rows and columns” filtering selection. Is this a feature in Pigment or are there plans to add this feature any time soon? Thanks!

2315

5 months ago

MarieJNewly Minted Pigmenteer

asked in Questions & Conversations

Board access

Hi there ; I’m trying to find a way to give access to only one board of an application ; To be more specific : I have the application "Budget", where the overall budget of the company is. In this application, I have multiple boards and I want to give access to (2 people) to only one of the boards (where they will find their own budget) but I don't want them to see the other boards (they don't have to see them). How should I do it ? Thx in advance

1403

5 months ago

Gabriel OrtizNewly Minted Pigmenteer

asked in Questions & Conversations

Calculating total price of subscription based on tiers

Hello Pigment community,I have a list of different clients that depending on the amount of users they are charged a different price based on tiers. Currently we do the process with an excel model that calculates the total price of the subscription based on a table that looks like this with the IFS formula:I would like to do this automatically on Pigment but I don’t know how to set it up so that based on the amount of users it multiplies such user for the correct price. Another limitation is that as you can see in the table there is the price of the Core service, and then there are different options that the clients can subscribe to. Therefore I also need pigment to multiply the usage by the correct options depending on what options each client has subscribed to. Currently in excel we do it by the means of this table: As you can see we use 1 as true and 0 as false. Thank you in advance,Gabriel

1084

6 months ago

cayleybNewly Minted Pigmenteer

asked in Questions & Conversations

Copying Saved Views from Metrics to Tables

Several times I’ve run into this… I think I can solve my problem by just manipulating a new view of a metric. Then I realize I need to combine several metrics. When I finally create a table I have to completely recreate the filters, summing, and pivoting in a table. Is there a way to duplicate a view in a metric into a newly created table? This would be very helpful!

571

6 months ago

OlaSeasoned Pigmenteer

asked in Questions & Conversations

Issues with time aggregations

I have a board with year as a filter on top of the board and it is possible to select multiple years in this filter. On my board I also have a KPI that should show outgoing HC for the last month based on the selected years. When I look at my data with Years on the rows it looks like the picture below when I use “Last” as time aggregator.However when I remove years from the rows all values are blank. If I change the time aggregator to “Last Non Blank” it shows me values, but the problem is that “Last Non Blank” doesn’t always give me the values for dec in the last year, it returns the cells shown in the second picture below. It feels like a bug that the cells are blank when using “Last” as aggregator in this case or am I doing something wrong?

1362

6 months ago

Tomer.ANewly Minted Pigmenteer

asked in Questions & Conversations

The Case for a Native Athena AWS-Pigment Connector

In our organization, we use S3 to store data as parquet files and work with Athena AWS. Currently, with Pigment's import mechanism based solely on integrated CSV files, we are compelled to establish a process that converts our parquet files into CSV. This isn't a favored method by our (BD&D) Team, to say the least. I can also elaborate on the pros of using the native connector to Athena AWS:Improved Efficiency: A native connector eliminates the need to convert parquet files to CSV for import into Pigment. This can significantly reduce the time and resources spent on file conversion, leading to improved efficiency in data operations. Enhanced Data Quality: Using a native connector can reduce the potential for data errors or loss that might occur during the file conversion process. Streamlined Process: Integration with Athena AWS via a native connector simplifies the data workflow, making getting data from S3 storage into Pigment easier and quicker. Increased Flexibility: A native co

1133

6 months ago

WillENewly Minted Pigmenteer

asked in Questions & Conversations

Allocate Product Groups down to Product level by % Mix

Hi - I’m new to Pigment having spent many years working with TM1 and am struggling with some of the new concepts and methods ! - Trying to find a way to allocate multiple Product Groups down to the Product level. I have the product mix % by Product Group but can’t find a way to only multiply the mix within each Product Group. In simple terms its:-IF (Product.Group (property of Product) = Product Group (Dimension) THEN Product Group* % Mix of Product in that Product Group.I was able to get it to work if I hard coded one Product Group (Type) but can’t find way to make dynamic on all product groups. Sales_By_Product_Group [Select: '02a.Product Type'.Type = "Barbecue"]*IF('02.Product'.Type = "Barbecue",'02.Product'.'% of Product Group Sales',0)In short is there a way to replace “Barbecue” so it iterates through all the Product Groups (Types) ? Thank you all !

872

6 months ago

DastanSeasoned Pigmenteer

asked in Questions & Conversations

Adding empty rows in Tables

Hi Pigment team, I’m trying to add empty rows into my Table block, so that I can separate some categories of expenses from each other: I tried to create and add empty “Placeholder” Metric, however it requires a name and I can’t simply leave it empty. Is there another way to add such empty rows between items? Best,Dastan

3606

6 months ago

charles.louis-lucasNewly Minted Pigmenteer

asked in Questions & Conversations

Import données format texte (nombre avec symbole)

Bonjour,Après un import des données, nous avons une colonne avec des montants incluant des symboles concernant les devises. Existe-t-il une solution pour récupérer seulement le nombre en dehors des différents symboles sans avoir a créer une liste de ces derniers ? Exemples : 100,000.00 € ; 100,000.00 kr ; 100,000.00 $ ; etc…Merci par avance,Charles

612

6 months ago

Jessica TNewly Minted Pigmenteer

asked in Questions & Conversations

Connector: Gsheet with Pigment

Bonjour, Je voudrais savoir si ce serait possible lors d’un extract de Pigment à Google sheet via le connector de ne pas avoir des lignes vides? Ex: Lors d’un extract avec le connector, j’ai 30.000 lignes et sur ses 30.000 lignes j’ai 10.000 lignes utilent et qui contiennent des valeurs. Cela alourdi énormément les fichiers de travail.Dans les tables (extracts) dans Pigment, il y a une possibilité de filtrer et de mettre (Hide empty rows and columns). Ceci empêche d’avoir des milliers de lignes vides pas utiles.Dans l’attente d’un retour, veuillez passer une belle journée :).Cordialement.TEGUA Jessica.

1994

6 months ago

Rahul KumarNewly Minted Pigmenteer

asked in Questions & Conversations

Using Scenarios in Formula

Hello Everyone, I am working on a headcount report where in I have Actuals and Budget along with the variance. Now I want to reference scenarios in the formulas somehow to create a metric to use this logic: If Actuals is blank and Budget is there, it means that that seat is not filled yet. Is there anyway to do it?

2404

6 months ago

NachoBudding Pigmenteer

posted in Questions & Conversations

Build BP from growth assumptions

I’m trying to start making hypotheses for next year's BP based on percentage growth.I started with Revenue but I find myself with the following problem that I am not able to solve.I simply want to formulate that the Revenue, for example, of January 2024 is that of January of the previous year * % growth. This % I have entered into a metric that I have created where I have put a % growth for each month of the year 24. However, I do not want the Revenue metrics already established in Pigment to vary or be modified, since they are the ones that give us our Revenue figures for different versions (actuals, forecast, target, etc.).Basically, what I want is to filter the information to which I want this % of growth to be applied, which in this case is only for the year 2024

3311

6 months ago

PaylwardNewly Minted Pigmenteer

posted in Questions & Conversations

Advanced Modeling Skills

Hello,I am working on a business case where I need to take the data and create some sophisticated business items. I want to see the forecast at different levels by who is inputting it and how to confirm the forecast is done. Here are some of the things that need to come out of the data that is provided.Alignment between top-down and bottom-up revenue targets. Consistent driver-based approach to cost planning, particularly around travel costs. Showing if forecast has been entered and how to change/override that number.Any help would be great.

841

6 months ago

Not Jeremy SternNewly Minted Pigmenteer

asked in Questions & Conversations

Aggregate vs. Import for Parent/Child Dimension Relationship

We have two dimensions that have a parent/child relationship - L0 Company and L1 Parent Company. For the exercise, here are some details:L0 has 500,000 items, L1 has 400,000 items This property will be upstream of a fairly complex cohorted revenue model Both dimensions are provided to us from Snowflake The date formatted property “First ARR Date” exists at the L0 Company levelWe need First ARR Date in L1 Parent Company in Pigment, what is the preferred way to do this to maximize performance?Aggregate from L0 to L1 in Pigment using a BY MIN Aggregate in Snowflake & import the First ARR Date into both our L0 and L1 dimensions A third option?Further, would the right way to do this change if the balance of list items between lists changed?

1593

6 months ago

AdamBudding Pigmenteer

asked in Questions & Conversations

Picking a dimension property dependently on scenario

Hi Pigment Experts, I have the following challenge. I have two properties in a an Employee dimension list (Department_Apr and Department_Mar). Employees may move between departments and these properties are reflecting that. Then I have a metric by Employee which I want to pivot by Department. I use the formula below and it works well. My question is is there a way to write formula so the metrics is either by Department_Apr or Department_May dependently on a Scenario i.e. dependently on input to another metric? The way it works now is that Department_Apr or Deparment_Mar are hardcoded but how to make these values a variable? if('Is Forecast (Headcount)', '361. Total Headcount Cost - A+F') [remove: '01. Payroll Waterfall', '01. Headcount Cost Account'][select: '01. FinType'."P&L"][select: '01. Version' = 'Version Push'] //."Mar Month End"][filter: '01. Employee ID'.OperRepairs = '01. Operations/Repairs'."N" and '01. Employee ID'.RetailTR = '01. Retail Branch / TR'."N"][by: '01. Emp

731

6 months ago

AlexandreSeasoned Pigmenteer

asked in Questions & Conversations

Top Decliners / Top Growth

Hello,I have this Table with 2 differents metrics (volumes L3M and volumes L6M to L3M) with Var and Var (%) as duplicates of volumes L3M. I analyze it month by month (basically the last month). I would like to have 1 view with top Decliners on the current month (automatically done each month), i.e the doctors who have the worst Var (%) (top 20) In another view I would like exactly the same but the best Var (%) (top 20).It seems impossible to do it with table view… Can you help me please ? Thanks

4051

6 months ago

dariousKeen Learner

asked in Questions & Conversations

Replace Blank Transaction List with Dimension

Hi Pigment Community!I am struggling with a problem and was wondering if any of you could help me solve it. The Issue: I'm working with a transaction block imported from Excel in Pigment, and unfortunately, not all the data is filled in. Specifically, I'm dealing with the Country/Region column in my All Deals transaction block. This column is dimensioned by Country Mapping, which, in turn, is connected to the Country dimension (screenshots attached for context). The snag I'm hitting is figuring out how to apply a formula that allows me to specify what information from my dimension to use when populating blank cells.The Goal: I aim to create a function in my Country/Region column that fills in blank cells with the dimension "Missing Data" for easy identification later on. The idea is to check the cell contents – if the cell is blank, I want to populate it with 'Missing Data,' sourced from my Country Mapping dimension. If the cell is not blank, I want to leave it unchanged. For instance,

5423

6 months ago

NakulNewly Minted Pigmenteer

asked in Questions & Conversations

Closing and Opening Balance

Need help on how to pull in previous month closing balance in Opening Balance Metric. Closing Balance refers to the Opening Balance. Basically Circular Ref, and just for ref need function similar to previous of Anaplan

1222

6 months ago

Cedric LJSeasoned Pigmenteer

asked in Questions & Conversations

Combine Previous(month) and BY modifier

Hi,In the below metric with 2 dimensions Month and Version, I try to combine a Previous (Month) and a BY.For now I have the error formula is invalid.The trick I found (please see the second screenshot) is to create a second metric “Other cash test” so I can apply BY .Thanks for your help,

1183

6 months ago

MKSMPBBudding Pigmenteer

asked in Questions & Conversations

How to align a property in one dimension with another dimension

Hi, I am looking to combine a transaction list (actuals) with a forecast metric using a cost centre dimension.I have the cost centre dimension in my transaction actuals but in the forecast it is a property in another dimension (property type is dimension and selected as the same one in the actuals). What function should i be using in my formula in order to bring both in combined at the cost centre level?

772

6 months ago

HarshilNewly Minted Pigmenteer

asked in Questions & Conversations

Show scenario variance and YoY variance in the same table

How can I show the scenario variance and YoY variance in the same table? I’d also like to be able to collapse month » quarter » year as needed. Currently, it’s showing YoY columns for all scenarios. Also, is there a way to restrict which metrics a calculated item pertains to? Lastly, is there a way to hide columns in a table? Thanks!

1552

6 months ago

KevinSeasoned Pigmenteer

asked in Questions & Conversations

Chart Legend Not Displaying Bottom Center

I am unable to properly display the metric in a chart legend below the line chart. The first screenshot has the legend in the bottom right and everything is fine. But when I moved it to the bottom center, the second value is not displayed. This chart is in a second view with one of the metrics hidden so perhaps that is causing the issue. But clearly the data is being displayed as needed but without the proper legend text. Any help to fix this would be much appreciated.

582

7 months ago

Page 7 / 27

Badge winners

TomOhas earned the badge Read and Interpret Formulas Certified
Dharani Ardhanihas earned the badge Pigment Modeling Fundamentals Certified
Bernadinehas earned the badge Pigment Modeling Fundamentals Certified
DavidEd1056has earned the badge Pigment Modeling Fundamentals Certified
Damien Khas earned the badge Pigment Modeling Fundamentals Certified

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Single Sign-On Need help?

Log into the Pigment Community

Single Sign-On Need help?

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.