Connect with other users, discuss how you're using Pigment, and get inspired
Recently active
Hi,I want to be able properly forecast the growth rate through time. Right now for Software, we select what month we’d like to grow the monthly cost and by what %. I’d like the formula to work as following:If the month is in an actual period, don’t grow the software period until the following year (example: if we had a software planned to grow in January, for 2026 we wouldnt see any growth but in January 2027 we would see the growth rate).Right now we have a super complex formula that really slows down the model: is there a more simplified way to calculate a growth rate %? Below are screenshots for an example calc based on the formula above: thank you in advance for all of the help!
The link on the page below does not work. Is there any place where I can view the webinar now?
Hi All,I know that pigment has a feature to automate notifications using a metric but is there a way to implement something similar for running Imports? Let’s say I checked off a boolean in a metric, is there a way to use that as a trigger for automatic metric to metric import?
Month after month, Pigmenauts share challenges, ideas, and solutions that help us all learn and grow together.To celebrate this knowledge sharing, here are February’s top 5 questions. We’re highlighting the ones that sparked the most interest and views from fellow members 💡.Whether you faced the same challenge or want to learn new tips, these threads are a great place to explore, contribute, and connect. Aggregate a formula Question - @msouss:“I have three metrics: Capa Test (Macro Resources, Month), Charge Test (Macro Resources, Macro Item, Month), and Saturation Test = Capa Test / Charge Test.When I use multi-selection, the KPI ‘Saturation Test’ doesn’t display the expected aggregated result (e.g. 132/185 ≈ 71%). How can I aggregate this formula to get the expected result?” Best Answer - @Francesca Royal:Instead of dividing the metrics directly, you can use Show value as → % of → Metric.Steps:Create a table including both Capa Test and Charge Test Add Capa Test again Select Show
Hi,I have a metric that pulls data from previous version and has metric override on. In current version, is there a way to delete data that came over from previous version without that cell reverting back to formula based result even if I don’t input any value.
Hello everybody!I'm trying to use a number-metric in which I have ranked all GL accounts as a mapping metric. I would like to allocate planned costs on level 2 to level 1 based on the top ranked L1 within each L2. My ranking metric produces this output. Based on this, I would like to allocate the costs that are planned on a higher level to PB61223. Can you point me in the right direction on how to go about this? I'm getting stuck in converting a number metric to a dimension metric. I have tried something like this but it doesn't work:IFDEFINED(FIL_TopRankedGLs[BY MIN: FIL_TopRankedGLs.’GL Account’] , ‘GL Account’ )
Hi everyone,I’m running into a problem with filtering months dynamically based on version in Pigment, and I’m not sure how to handle it. Here’s the situation:Context: I have a table with Version in rows and Month in columns. I created two metrics (both identical, boolean, dimensioned by Month and Version): A filter metric that marks which months are related for each version. Example: New Biz 2025 → Sep-24 to Dec-25 = TRUE New Biz 2026 → Sep-25 to Dec-26 = TRUE A data-entry metric to “open/close” months for each version. This ensures that, when a version is selected, only the relevant months are shown, not all months. Problem: I added both metrics to a table and tried to apply a filter to display only the months marked TRUE by the filter metric. Pigment forces me to select a specific month if I try to filter across all versions. It also forces me to select a specific version if I try to filter across all months. In short, I cannot apply a filt
Hello community,I was wondering if there was a way to display more information when you hover over one cell. For instance when i display top 10 clients upsell of one month i display only the name but would like to be able to see other dimensions (region, sales owner, ...) when you’re hovering the name of the client.
I want to set up a variable item that i can use as a default filter on my Boards.I want it to default to the local currency of a selected subsidiary.I have tried creating a mapping metric, dimensioned by Subsidiary and with the data type = currency dimension. I have also tried it as a boolean with subsidiary and currency as dimensions.Neither are available for selection when trying to set up the variable.How can i get this to work?
Hi,Can a notification be triggered even when the Automation has been turned off? I have been receiving emails even though I have the notifications turned off. There are no changes in the model history to point to what triggered it.
Hello,I was wondering if it is possible to create a CAGR % in a table (via calculated items or SVA). At the moment I have a separate metric that calculates a CAGR on a granular P&L level, but once I pull that metric in my table it simply sums or flat-out averages that metric for the higher P&L levels.Does anybody know if there is some smart way to recreate a CAGR SVA or calculated item in a Pigment table?Thanks, Bas
Hi Everyone,I have a metric based on TRx data (quarter-wise: Q1–Q4) across multiple Accounts, with dimensions including Region and Version (e.g., Forecast FY24).I want to identify the top-performing account within each Region and Version based on the highest TRx value (either quarterly or total for the year).I tried using the RANK function, but I’m only able to rank by grouping on a single dimension. I’m not able to rank dynamically by multiple dimensions together (Region + Version). It seems like the grouping works only for one dimension at a time.What would be the best way to write a formula or configure this in Pigment to dynamically return the top account by both Region and Version?Any guidance on the correct approach (ranking, max aggregation, scoped ranking, or another method) would be really helpful.Thanks in advance!
Hello Pigment Community,We have replicated our monthly reporting pack in Pigment, which was previously in Google Sheets. One key function (and final touch) that would make it identical to our files in Google Sheets would be the ability to add comments in the right hand margin for each income statement line of our variance analysis.I’ve reviewed Pigment’s commenting functionality, which works well, but is not suitable for our use in this instance. We’re really set on having the comments visible, and being able to archive them. Here’s our specific requirements:Be able to archive comments by period, version (actuals vs. forecast, actuals vs. budget, etc.), and by income statement line. For example: Imagine I am reviewing the May 2023 Actuals vs. Budget Income Statement variances. I comment to the right of the Revenue line “Revenue underperformed due to X, Y, Z. If in a year’s time, I filter on the month of May, for the May 2023 Actuals vs. Budget Income Statement, I’d like to be able to
Hello, I noticed that there were some adjustments made to view aggregators functionality in widget. Previously it was possible to remove the total from the dimensions in grid an copy it over to every metric, but now this button is unavailable. Are you planning to restore it? Thank you!
Hello Team, Do we have an option to export Block History in Pigment ? if not, do we have alternatives to do an analysis for the block changes / overrides made by the end-user against the time period. Thanks !
Hello,I have 3 metrics :- Capa Test (Dimensions: Macro Ressources, Mois)- Charge Test (Dimensions: Macro Ressources, Macro Item, Mois)- Saturation Test (Dimensions: Macro Ressources, Macro Item, Mois) : Saturation Test = Capa Test / Charge Test But as you can see, when I use a multi-selection, the KPI “Saturation Test” doesn’t display the expected result (which would be 132/185 = ~71%).Do you know how I can aggregate this formula in order to have the expected result ?Thank you very much
BonjourExemple :j’ai 2 dimensions, une rayon et une critère, je voudrai pouvoir ne faire apparaitre que les critères relatifs au rayon afin de limiter la selection.J’ai crée une metric de type bolean CP1 , cela fonctionne quand les critères sont exploitées en ligne mais pas en page merci pour votre aide
I have a transaction data containing 3 columns:QuarterAccountSales OrderI need to insert rank columns wherein the condition is:For an account whenever gets any Sales Order in a quarter, it should be assigned a rank for the line items for the quarter in ascending order of the quarterExample1:Quarter Account Sales Order Rank 2024-Q3 Alpha 100 1 2024-Q3 Alpha 200 1 2025-Q2 Alpha 300 2 2025-Q3 Alpha 50 3 2025-Q4 Alpha 70 4 2026-Q2 Alpha 80 5 Example 2:Quarter Account Sales Order Rank 2024-Q2 Beta 50 1 2026-Q1 Beta 10 2 2026-Q2 Beta 20 3 Thanks in Advance!
Introduction:Hello Pigmenteers! My name is Bryan Bauer (@Bryan Bauer in the community). I am an FP&A Manager at Aurora, a self-driving technology company based in Pittsburgh. I support our product engineering organization as the finance business partner for Software Products and previously supported Hardware Products. You can see Bryan’s full interview here: Tell us a bit about your career journey. How did you end up in FP&A and working with Pigment?My path to finance has not been straightforward. I did not want to go to college, but I eventually went because I had to, and I chose math simply because it was the subject I disliked the least. I studied industrial mathematics for my bachelor’s degree.I later discovered that while every job uses math, almost no one is hiring a pure mathematician. So I went back for a master’s in petroleum engineering, and worked in oil and gas as a drilling engineer for around seven years. Over time, the work started to feel repetitive and I found
At Pigment, we’re committed to creating meaningful experiences that go beyond the product itself. To keep doing that well, we need your input. We’ve put together a quick 2-minute survey to better understand what resonates with you and to help guide our marketing efforts. Your feedback directly helps us tell more relevant, useful stories, and build experiences that truly add value. Thanks so much for taking a moment to share your thoughts. We really appreciate your support! English SurveyFrench Survey
I currently have a table with months and years in the columns and metrics in the rows. I want to have a YoY% appear as a column after each year for all metrics. i.e. FY26 | YoY% | FY27 | YoY% |Is this possible and if so, how to I go about it?
Hi everyone,I’m a Pigment newbie, and I need support from you !I would like to manually sort the Items of a Dimension displayed in a Pigment Object.Let me show you an example :In the picture below, I want the “NA1” to be between “AU7” and “IN1”.I selected “No Sorting”, but I didn’t manage to drag & drop the NA1.Thank you !
I have 2 lists, lets call them ‘list1’ and ‘list2’. ‘list2’ has two properties with all values populated: ‘name’ and ‘product’. ‘name’ is a text property with duplicative values and ‘product’ is a dimension ‘product L0’. ‘list1’ has the same properties, with only ‘name’ populated. What formula can I in the ‘product’ property from ‘list1’ to call ‘product’ from ‘list2’ by looking up ‘list1.name’ against ‘list2.name’?
Hi,I am trying to build a forecast in Pigment which can have multiple versions. Is there a way, we can lock formulas in versions? I know there is a scenarios feature, in which we can have formulas for different scenarios. Are scenarios the preferred way of versioning in Pigment? Thank you
Hi Community,I’m currently exploring the Pigment × ChatGPT integration using the new MCP server. However, it appears our IT team is not comfortable enabling Developer Mode in ChatGPT.Does anyone know when the connector is expected to become verified so we can integrate Pigment with ChatGPT without needing to rely on Developer Mode?ThanksNeo
Already have an account? Login
Single Sign-On Need help?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
