Skip to main content

Explore the Community

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

984 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

510
Isabella Leslie-Miller
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

10901
abhilashsawla
R
Just Arrived
ryanrOJJust Arrived
asked in Questions & Conversations
Integrate Rippling with Pigment

We use Rippling for HRIS and Payroll. There is no native connector. I am looking for specific guidance and best practices on how to integrate them. I will share this info with IT and my consultant. Thanks.

20
R
Just Arrived
K
Budding Pigmenteer
keerthanarameshBudding Pigmenteer
asked in Questions & Conversations
Percentage mix calculation

I’m trying to calculate fee % on the total amount. Both metrics have the same 5 dimensions. However my output when I directly calculate it as a formula is different from when I use Calculations “show value as” in the table which is correct.Since both have the same dimensions, how do I get the correct % at all levels of the dimension?The first is from “show value as” and the second is from a metric. How do I get both of these to be correct and the same? 

81
Min Li Bright Point
CamilleMomo
Seasoned Pigmenteer
CamilleMomoSeasoned Pigmenteer
asked in Questions & Conversations
NETWORKDAYS error ?

Hi,When an holidays lands on a non working day NETWORKDAYS deduce twice the day. Is it normal ?Thanks

61
CamilleMomo
Seasoned Pigmenteer
E
Newly Minted Pigmenteer
EdgarNewly Minted Pigmenteer
asked in Questions & Conversations
Cumulate by Qtés

Hello community,I'm looking for a cumulate grouped by Qty. I have a first metric which indicates my need of Qtés per week, and I need a second metric able to detect the week when I exceed the minimum to order. In my example, I have a minimum order of 6. In Line 1 I calculate my requirement per week. (that's done)In Line 2 I want to trigger an order when I've reached at least my minimum order.If I have that, it's already good In an ideal world, I'd have to reduce this quantity to the 1st week, a bit like a moving sum function but with variable parameters. If anyone has an algo idea, I'd be grateful ^^. 

171
E
Newly Minted Pigmenteer
Bas
Budding Pigmenteer
BasBudding Pigmenteer
asked in Questions & Conversations
Filter on item variables in page selector

Hello,I might have a really simple question, but I can't quite figure it out. Is there a way to show the available item variables in a page selector on a board? If I go into the page selector options by clicking on the edit button on a board I can see all available item variables for a specific dimension (for example under ‘available items’ or ‘default items’). But via de dropdown on the page selectors themselves it is not possible to use the variable as a filter? The specific underlying use case is that I have created a subset of profit centers and I would like the end users to be able to view that specific subset of profit centers by filtering the page selector. They shouldn't manually have to click one-by-one.I hope my question is clear :-) Thanks a lot everybody!Bas

253
Benoit
Community Manager
Omer Nahum
Omer NahumFrequent Reader
asked in Questions & Conversations
Permissions for the new dimension mapping capability

Hi Pigment,I shared with our team the new dimension mapping capability but they can't use it, what access rights and permissions they should have in order to do it?https://community.pigment.com/reporting-data-visualization-83/group-data-dynamically-with-mapped-dimensions-3160Thank you,Omer.

272
Omer Nahum
C
Newly Minted Pigmenteer
CaitlinNewly Minted Pigmenteer
posted in Questions & Conversations
Cells with no value/blank should have an option to display as 0 or '-'

From a reporting standpoint, it looks odd to show cells with no values as blank. When putting together a Board report, I would always ensure that nil values show as zero or dash. Can the display of blank cells be considered, same as we have the option within formatting to show as 0 or -?

141
Benoit
Community Manager
H
Newly Minted Pigmenteer
HALYNewly Minted Pigmenteer
asked in Questions & Conversations
Locating Model ID and WS ID

Hello, Seems like a silly question to ask but I am having a hard time locating the model ID within a model and can’t locate this info in any documentation. On a similar note, where do you locate the workspace ID? Thanks for your support,HA

201
F
Employee
C
ChahatKeen Learner
posted in Questions & Conversations
Access Rights of 'Trigger Export' data action

Hi all,If I use the impersonate feature and clicks on the button which triggers an export (action button : data action : trigger export) which have n number of metrics, and if all the n metrics are having the same Access Rights applied on those because they are all on the same dimensionality, then in the Export view, it shows all the data irrespective of the access rights and impersonation.Hence, in order to see the export view from the actual user’s perspective, that person needs to login for triggering the export, because impersonation doesn’t work as expected for the data action -- trigger export (with AR applied on it)Regards!

90
C
CDALMAY
CDALMAYKeen Learner
posted in Questions & Conversations
T&D Deployment Improvement

Currently, if you try to deploy an application from one environment to another, you might ran into this issue : It would be useful to know which app (just the name) you don’t have access to.

140
CDALMAY
V
Budding Pigmenteer
venitiavBudding Pigmenteer
asked in Questions & Conversations
Skip to line text in metrics

Hello,Is there an option to skip to line when the text is long on a metric ? There would be enough space to write :“YTD internal heacounts (end of month)”Thank you 

253
Isabella Leslie-Miller
Community Manager
M
Just Arrived
Md SaquibJust Arrived
posted in Questions & Conversations
Dimension Column Width Setting

There should be an option or setting to adjust the column width for all columns in the Transaction List/Dimension List at once. Currently, column width can only be adjusted individually per property. A global setting to apply the same width across all columns would enhance usability and efficiency.

91
Isabella Leslie-Miller
Community Manager
Isabella Leslie-Miller
Community Manager
Isabella Leslie-MillerCommunity Manager
published in Career Forum
Career advice from a finance leader at BNP Paribas and JPMorgan

Dennis, Head of Securities Services Americas at BNP Paribas, gives us a guided tour of his career, the principles he follows for success, and his forecast for the next five years. If you’re pursuing a career in financial services, Dennis Bon is a strong candidate to model yourself on. Dennis is Head of Securities Services Americas at BNP Paribas, holding positions at JPMorgan and ABN AMRO prior to that.We sat down with Dennis recently to reflect on the decisions he’s made throughout his career, the advice he’d give to people earlier on in theirs, and where he thinks the industry is going next. Did you always have a ‘grand plan’ for your career? No is the short answer. But what Dennis did have were three principles that he thinks have served him well:A constant desire for learning and change Every 3-5 years, Dennis finds himself doing something different - usually coming with fresh challenges and more responsibilities. An appetite for risk The first principle necessitates this one, real

130
Isabella Leslie-Miller
Community Manager
Spandan98
Seasoned Pigmenteer
Spandan98Seasoned Pigmenteer
asked in Questions & Conversations
Practical Use of List-List Import Feature

Hi everyone,Yesterday, that is on 19/06/2025, the feature “List-List Import” feature was released and I believe its a great feature,  but I want to know about the practical usage of these feature, like what are the scenarios where we should use this feature, It would be great if someone can help me understand.Thanks everyone!

1055
oliverlee
Seasoned Pigmenteer
V
Newly Minted Pigmenteer
valefNewly Minted Pigmenteer
asked in Questions & Conversations
Cumulate function

Hi everyone,I'm trying to use the cumulate function to sum only the FY26 months of the metric Nexus Lowest Level, but the output includes all years instead of just FY26.Has anyone run into this or knows how to fix it?Thanks in advance! 

334
V
Newly Minted Pigmenteer
Catalina Ibarra
Community Manager
Catalina IbarraCommunity Manager
published in Company News
New Features To Fill Your SummerNewsletter

This June, there are several new product enhancements at your disposal! Check them out below and sign up for our upcoming Product Webinar on July 24th to learn about other useful features and those coming soon. 📝 Import data List-to-List 📈 Chart zoom for better exports ↪️ Use Top navigation in Sequences 🎨 Customize your Application icon color 🔒 Simplify security with access rights Dimension replacement 🚀 Deploy import configurations with ease 👣 Track last activity on Items in Lists 🌐 Product Webinar & Virtual User Group - July 24th 📣 Pigment Customer Advocacy Program: Get rewarded for your support 👥 Virtual Roadshow - July 29th  Import data List-to-List  You can now import data directly from one List to another using List-to-List Import. Map source and target Properties with matching data types, add filters if needed, and run the import manually, with an Action button, or on a schedule.  Chart zoom for better exports  You can now zoom in and out on chart text for better re

260
Catalina Ibarra
Community Manager
Isabella Leslie-Miller
Community Manager
Isabella Leslie-MillerCommunity Manager
posted in Welcome to the Community!
Introduce Yourself - 2025

Welcome to our annual introductions thread!We hope you’ll use this as a place to share a little more about yourself and get to know the other members in our community. Tell us where you work, a bit about your role, where you live and how you use Pigment. Add any interesting facts about you or even a nice picture that means a lot to you (like in a cool place, or with a pet)! If you want to see our past introductions thread for some inspiration, look here. I’ll get the ball rolling:Hi! I’m Isabella - I’m the Community Manager here at Pigment and I’ve had the great privilege of working here for around 8 months. Before Pigment I worked at a data science education company, and my academic background is in Mathematics and Finance.I’m originally from South Africa and moved to the UK around 3 years ago - I’m now based in lovely Harrow. Outside of work you’ll typically find me reading, gaming, traveling, going to a gig, or building a cool cosplay for Comic Con.I’m looking forward to getting to

2623
Catalina Ibarra
Community Manager
Isabella Leslie-Miller
Community Manager
Isabella Leslie-MillerCommunity Manager
published in Career Forum
Career Spotlight - Clement Dalmay

Introduction: Hello Pigmenteers! I’m Clément ( ​@CDALMAY  in the community). I’m based in New York, where I’ve been living for the past seven years. I’ve been working with MeltOne for nearly three and a half years now and over the last decade my career has been focused on FP&A and financial planning tools.I started out with Oracle-based solutions, transitioned to Tagetik as a technical architect, and then discovered Pigment in 2022. Since then, I’ve been mainly focused on Pigment, with about three years of hands-on experience which is half the lifespan of the platform itself! You can see Clément’s full interview here:  What advice would you give to someone new to FP&A or Pigment?Always be curious and willing to learn new things. You’ll make mistakes, that’s part of the process, but hands-on experience is the best teacher. Don’t be shy For those new to Pigment: start with the Academy. It’s structured, practical, and a great foundation. Pigment is easier to learn than many legacy

260
Isabella Leslie-Miller
Community Manager
Brian Mondello
Newly Minted Pigmenteer
Brian MondelloNewly Minted Pigmenteer
asked in Questions & Conversations
ISFIRSTOCCURRENCE formula for dimension creation

With the new functionnality to create dimension based on an other dimension/transaction list, I want to create a concatenation of 2 columns in my transaction list but.. Pigment say there is an error because a lot of rows don’t have unique ID. Is it existing a “ISFIRSTOCCURENCE” formula or simithing similar to filter my view and solve the point ? 

533
Yuri Pinchuk
Budding Pigmenteer
G
Newly Minted Pigmenteer
gttNewly Minted Pigmenteer
asked in Questions & Conversations
How to lookup property value of dimension?

Hi, I am trying to create a Boolean metric with Month as the only dimension member. I want to write a formula where if the month is greater than eg. “April 2025” and less than or equal to ‘Last Actual Month’ (Month dimension property member of ‘Save Version’) of ‘Save Version’.”Live Version” then TRUE but I am having trouble calling the ‘Last Actual Month’ of ‘Save Version’.”Live Version”.I think ideally I would be able to pull something like ‘Save Version’.”Live Version”.’Last Actual Month’ but surely it can’t be that simple? 😅

372
G
Newly Minted Pigmenteer
R
Newly Minted Pigmenteer
Rahul KumarNewly Minted Pigmenteer
asked in Questions & Conversations
Circular Dependency on Transaction List and dimension

Hi Team,We have an input transaction list for new seat requests. In this list, a manager and above can come an ask for a new seat / headcount and that is determine by Supervisory Org. So if I am a Senior Manager, I can come and request for a Manager position and so on.   We also have a dimension list called Supervisory Org 1 which determines what is the Org of an employee and what are the levels above. Now we want to pull the levels for the new seat based on the manager’s level. But this is giving us the circular reference error.​​​​​​Bottom line is we are using the dimension list to pull the levels in transaction list based of of hiring manager level and now we want to put it back in the dimension for the hiring position. Any workaround for this situation?

331
Luiza
Employee
C
ChahatKeen Learner
asked in Questions & Conversations
Submit Button

Is there a way in Pigment to submit a button?(i.e. similar to marking a checkbox as True)

503
C
G
Newly Minted Pigmenteer
geoff_chovazNewly Minted Pigmenteer
asked in Questions & Conversations
SFTP connection

I am receiving an error “xxxxxxxxxxxxxx is not a valid unix username” when trying to establish an SFTP connection. The username is quite long - 27 characters. The connection works in other SFTP clients like Filezilla using the exact same parameters. Any ideas? 

353
Gabriel Amaro da Luz
Employee

Badge winners

  • Pigment Modeling Fundamentals Certified
    nathanboldthas earned the badge Pigment Modeling Fundamentals Certified
  • Read and Interpret Formulas Certified
    Alexplhas earned the badge Read and Interpret Formulas Certified
  • Read and Interpret Formulas Certified
    livimaceyhas earned the badge Read and Interpret Formulas Certified
  • Pigment Modeling Fundamentals Certified
    JonCushinghas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    JonCushinghas earned the badge Pigment Like a Pro
Show all badges
Terms & ConditionsCookie settings