Skip to main content

Explore the Community

Connect with other users, discuss how you're using Pigment, and get inspired

844 Topics
Isabella Leslie-Miller
Community Manager
Isabella Leslie-MillerCommunity Manager
published in Company News
Pigment recognized as a Visionary in its first inclusion in the Gartner® Magic Quadrant™ for Financial Planning SoftwareNews

Today, we’re pleased to announce that Pigment has been recognized as a Visionary in our first inclusion in the Gartner® Magic Quadrant™ for Financial Planning Software. We believe this recognition validates the hard work that’s gone into building the Pigment platform and how we’ve partnered with our customers over the past few years. We’d like to thank our customers, partners, advisors, and employees, past and present, for getting us to this point. Inclusion in the Magic Quadrant™ is a significant milestone for Pigment, and it gives the team great confidence as we move into 2025 and beyond. To download your complimentary copy, click here. Gartner disclaimer:Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statem

280
Isabella Leslie-Miller
Community Manager
KarlW
Community Manager
KarlWCommunity Manager
published in Company News
Level up your Pigment formula knowledge with new learning experienceNews

Introducing Formula Writing: Unlocking Dimensionality and Calculations We've heard your requests for more formula & calculation training, and we're excited to announce our new Pigment learning path!   The training is split into two parts:Read & Interpret Formulas - Perfect for those who need to be able to create inputs and analyze outputs! You'll need just a couple of hours, and you'll be able to better define requirements and understand the calculations available to you.   Write & Test Formulas - Hey modelers, this one's for you! This new learning path will offer a deep-dive into the most helpful modifiers and offer real-world exercises to solidify your learning. These new learning paths are NOW LIVE in the Pigment Academy! Click below to get started:START LEARNING NOW

2520
KarlW
Community Manager
Isabella Leslie-Miller
Community Manager
Isabella Leslie-MillerCommunity Manager
published in Welcome to the Community!
Welcome to the Pigment Community! 🎉

Welcome to the Pigment Community!We’re so grateful to have you here! The Pigment Community is your place to collaborate with, learn from and inspire other Pigmenters. Why should you explore the Pigment Community? 🔎We want you to be as confident as possible with Pigment. Through the Community, you get to engage with peers to share knowledge and expertise on using Pigment. We encourage you to share your insights and learnings, as others might well be facing similar questions. Above all, we want Pigment users to connect and engage with each other! I’m new here, where should I start? 👀💡 Good thing you asked – here’s how to get started!Register and complete your profile. Add a profile picture and fill out your profile details. Introduce yourself! We encourage all of our new members to introduce themselves in our Intro thread. I saw someone with a shiny badge and cool title, how do I get one? 🏅We reward active users publicly through a variety of badges and titles. Once you start posting

9101
abhilashsawla
F
Newly Minted Pigmenteer
FPA
asked in Questions & Conversations
syncing context pages across multiple tabs

Hi, we have users that work on multiple boards at the same time that share common pages selectors.The challenge here is that when we switch from one dimension element to another on the page selector in one tab, we need to go through each other tab to adjust the page to the newly selected element. As people here work with like 10 tabs in parallel, that s a lot of clicks to update boards and have them being synced.Do you people encounter those kind of usage / challenge ?Are there ways to make this work in pigment and how if you experimented it ?I was thinking maybe using a custom user defined variable ?

40
F
Newly Minted Pigmenteer
M
Newly Minted Pigmenteer
MaxenceGoigNewly Minted Pigmenteer
asked in Questions & Conversations
Impact of Data Import Modifications on Pigment

Hi,I have a transaction list where data is imported daily from NetSuite into Pigment.Some modifications will be made to the NetSuite search where the data comes from, including the addition of new columns.I’m am not sure how this change will impact the import process in Pigment?Additionally, when I go to Import Data → Set Up Import, the data mapping does not open—it just keeps loading indefinitely. Does it mean I will have to recreate an import from scratch?Thanks in advance for your guidance!Best regards,

211
M
Newly Minted Pigmenteer
T
Newly Minted Pigmenteer
Ta-WingNewly Minted Pigmenteer
asked in Questions & Conversations
Pigment AI

Tried enabling pigment AI but when I ask a simple question like “What’s the revenue in 2024?”, it is giving me a total Revenue that isn’t filtered, i.e. before drilling into FX25 or 24, Live & Stage version combined, 0+12 to 12+0 versions combined? 

271
Min Li Bright Point
F
Newly Minted Pigmenteer
FPA
asked in Questions & Conversations
does test and deploy allow disconnected scenarios ?

Hi,I d like to know whether the scenarios under deployed applications (test n deploy) can be set to "disconnected" (except the default scenario(s)) ?The need here is to have basic scenarios with predefined rules to calculate baseline projections while alowing users to add scenarios with ad hoc simulations formulas.  

331
Julien
Community Manager
julian_s
Newly Minted Pigmenteer
julian_sNewly Minted Pigmenteer
asked in Questions & Conversations
WF Planning: Remove Lastnonblank month Gives A Different Return

Hi Folks, struggling with an issue here. I have HC by dept over time. What I’m trying to do is take the last month of actuals, in this case December. In the example below, its 805. However, when I remove lastnonblank month, the amount jumps to 917. What I noticed when I drill into the 917 is that while month is taking the last month, the other dimensions are being flattened so counts are duplicating where things have changed over time. How do I take the lastnonblank of the other dimensions as well?

291
Min Li Bright Point
N
Budding Pigmenteer
NachoBudding Pigmenteer
asked in Questions & Conversations
Comparison of different scenarios

We’ve created two scenarios for the BP on 24: Target and BudgetThese two scenarios are items belonging to the dimension “Version”.In the attached table, we want to add two new comparative columns, one being "Target bp 24/FY23" and the other "Budget bp 24/FY23". However, it does not allow us to add this calculated item because we cannot compare different dimensions (version and year).How can we do this comparison? it is crucial to be able to compare as many scenarios as we want with the previous year's figures  

7949
K
Budding Pigmenteer
J
Newly Minted Pigmenteer
Juned.husainNewly Minted Pigmenteer
asked in Questions & Conversations
How to do Unique Count?

Hello Everyone. I am a beginner in Pigment and I am trying to replicate my excel model within pigment. My current excel model will take a unique count of my order number (order number replicates due to multiple sku in one order) and mark the order as 1 and the duplicate as 0. Example: (if A2=A1,0,1). This gives me the unique number of  orders in my transaction list. I cannot reference a cell directly using the if formula in pigment as compared to excel. Is there a an easier way to do this in pigment?  

656
Nathan
Employee
J
Newly Minted Pigmenteer
Juned.husainNewly Minted Pigmenteer
asked in Questions & Conversations
Missing data after upload

Hello All,I accidently changed the data type for the column ‘order number’ from Text to number which resulted in the data being deleted. I changed the data type back from Number to text and tried reimporting the data back but it still does not shows the original data. Any help is appreciated  

101
oliverlee
Seasoned Pigmenteer
V
Budding Pigmenteer
venitiavBudding Pigmenteer
asked in Questions & Conversations
Add a metric in a dimension list from another source

Hello,I created a new metric named "EmpData-Allocation" (with dimensions "employee" and "month") filtering only the existing employees, that I fill each month manually with a dimension named "allocation". How can I add this metric by employee to the dimension list "employee" ?  example :My employee transaction list is an import from Workday. In this transaction list, I have a new employee named “Employee1”.In my dimension list “Employee”, I have all the info for Employee1 coming from this employee transaction list. In the metric "EmpData-Allocation", I put Allocation1 for Employee1. I would like to have this Allocation1 next to Employee1 in the Employee dimension list. Can you please advise ?  Thanks

262
V
Budding Pigmenteer
Spandan98
Budding Pigmenteer
Spandan98Budding Pigmenteer
asked in Questions & Conversations
Restricting Input Based on Conditional Formatting in Pigment Metrics

Hello Pigment Community,I hope you're all doing well!I’ve created a table with the following metrics:Month Amount Blended Interest(Please refer to the attached screenshot for reference.)Currently, I have a checker metric set up for conditional formatting, which highlights a month in red if it is greater than the closing period.Here’s what I’m trying to achieve:If a month entered is greater than the closing period, I want the Amount and Blended Interest metrics to become non-editable so users cannot input data in these fields. If a month entered is less than or equal to the closing period, users should be able to input data as usual in these metrics.Could anyone guide me on how to set this up in Pigment? Your assistance would be greatly appreciated!Thanks in advance!    4o

261
W
Employee
B
Newly Minted Pigmenteer
Bryan BauerNewly Minted Pigmenteer
asked in Questions & Conversations
Changing Data Types of a Metics and Removing the Current Value

I have a metric that includes three dimensions—DimA, DimB, and DimC—along with a corresponding dollar amount for each intersection. I’d like to create a new metric where DimA and DimB remain as dimensions, but DimC becomes the result instead of a dimension for each of the intersections in the first metric. In doing this, I also want to drop the numeric data type and just have it as a dimension data type What would be the best way to achieve this in Pigment?

463
B
Newly Minted Pigmenteer
Yuri Pinchuk
Newly Minted Pigmenteer
Yuri PinchukNewly Minted Pigmenteer
asked in Questions & Conversations
odd situation with CSV import

Hi Community!I've faced with the wierd problem while importing data from CSV to Transaction List.In CSV file the text field value is "Central LATAM” - the second part in uppercase, but when importing I've found this field in Pigment Transaction list as “Central Latam” - with only first letter uppercase.What could be the reason and how to avoid it during import? Many thanks!Yuri

152
Yuri Pinchuk
Newly Minted Pigmenteer
S
SuzzyOccasional Observer
asked in Questions & Conversations
How to cumulate but with Start Date

Hi, I would like to consult what is the best formula to Cumulate a metric where I need to add a start date. To give more context, this is the current formula I have:CUMULATE('Metric1', month dimension) [SELECT: month dimension-3]I need to deduct 3mos as well thus there is -3 in the formulaThe start date of my cumulate should be from January 1, 2023  Thank you! 

342
S
Spandan98
Budding Pigmenteer
Spandan98Budding Pigmenteer
asked in Questions & Conversations
Dynamic Cell Access in Pigment

Hello Pigment Community,Do we have dynamic cell access feature in Pigment?For example: I want users to just edit the Vintages and not the vintages that are already filled. (Context: This is a calculated field, but I have allowed data input override of the metric)How can I just edit the Vintages and add values to the Vintages that are not filled and the ones that are filled or already calculated be non editable? Please kindly help.Thanks!

171
Matt D
Employee
Abhay
Just Arrived
AbhayJust Arrived
asked in Questions & Conversations
You do not have access to any of this metric data - Workforce Planning

Hi Team,While implementing Workforce planning for Pigment PRO Training, there’s a requirement where we are suppose to write formulas for Annual Benefits, Annual Bonus etc. While implementing this, I have noticed that - I am getting some warning which says “You do not have access to any of this metric data” as I am trying to fetch metric from another application. Please note that, I have made sure that - Shared Block is activated for my dimensions, metrics in Data Hub Application. Can you please let me know what could have been wrong in this case? 

281
Min Li Bright Point
M
Budding Pigmenteer
MohanBudding Pigmenteer
asked in Questions & Conversations
Slicer Buttons

currently the user needs to expand the filter selection and select the specific filter criteria. Was wondering if there is any action buttons similar to “SLICERS” in Excel ?

5125
M
Budding Pigmenteer
L
Just Arrived
LASJust Arrived
asked in Questions & Conversations
Select N Number of Months Back

I am trying to select N number of months back fin a given metric based on an in Input Metric. The Target Metric is dimension by Type in the rows and Month in the Column. The Input metric is dimensioned by Type and I have assigned a differing number of months to each type. The Calculation Metric in which I am placing the Formula should offset and select the value N Number of Months back based on the Input Metrics Months.Here is an example formula:Formula Metric:‘TargetMetric’[SELECT: Month - InputMetric] but this throws an error about the month dimension.How can I select a certain value from the target metric N number of months back based on an Input Metric?

502
Min Li Bright Point
M
Just Arrived
Mitch MaxJust Arrived
asked in Questions & Conversations
Excel Connector questions

Great to see this new functionality!  2 questions:Is there a way to preserve formatting in Excel (i.e., to refresh data in a report) I cannot see an option to “push” data, only to pull.  What am I missing?Thanks! 

3943
Sharon Conroy
Community Manager
agnar
Seasoned Pigmenteer
agnarSeasoned Pigmenteer
asked in Questions & Conversations
Conditionally format dates

Can I conditionally format dates? I only see the option to conditionally format based on text or value

3012
Sharon Conroy
Community Manager
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Shared Scenario Usages

How to check the usage of a shared scenario?

502
P
S
SusmitaOccasional Observer
asked in Questions & Conversations
Highlight Text or Boolean metric using Conditional Formatting.

Is there any way to highlight Boolean formatted or Text formatted metric using Conditional Formatting ?

3916
Sharon Conroy
Community Manager
julian_s
Newly Minted Pigmenteer
julian_sNewly Minted Pigmenteer
asked in Questions & Conversations
Downloading Dependency Diagram

We’re supposed to have a download button for the dependency diagram but it isn’t showing up for me. Any idea why? 

505
RoryC
Community Manager

Badge winners

Show all badges
Terms & ConditionsCookie settings