Skip to main content

Explore the Community

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

944 Topics
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
NETWORKDAYS formula

Hello,  Can you please help me creating a formula to show net working days for each month?The excel formula will be like this: So far, I created a dimension  I referenced the article here but could not really understand what I should do to get list of working days for each month.  Thank you!

9942
Y
Newly Minted Pigmenteer
K
Budding Pigmenteer
keerthanarameshBudding Pigmenteer
asked in Questions & Conversations
Multiple Break down levels

Hi,What’s the criteria to have a another level of breakdown?I was able to have two levels of break down for one of the metric but for the boxed one “R&D SAAS Total” another level of break down doesn’t show up even though the  dimensions are all different for each level that I wanted to select. Can anyone share what is the rule/condition to be followed for such multiple level of break down in a table?Thank you! 

7474
K
Budding Pigmenteer
E
Newly Minted Pigmenteer
Eva LacauNewly Minted Pigmenteer
asked in Questions & Conversations
Equivalent of vlookup between text format

Hello, can you please help me with this formula ?I would like to do a formula similar to vlookup between Unique item values (text format) of two transaction lists (check if a transaction list contains (or not) the Unique item values of the other transaction list → if Unique ID of TL1 is in TL2 then yes, otherwise no) Is it possible to use vlookup equivalent between text format values, or do I have to create a dimension ? Thanks in advance!

4196
Nathan
Employee
Benji
BenjiPigment Academic
published in Career Forum
The FP&A Jobs Report #49 (Ankorstore, Crocs, Wolt, Uberall...)

For all the new joiners, a quick reminder of what you get with this newsletter:👉🏾 Around 10 fresh job offers👉🏻 From top companies worldwide👉 Every weekExecutive Positions  [MANUFACTURING] VP of FP&A ,📍Atlanta, US "This role will also provide strategic financial analysis, recommendations and guidance to the Executive Leadership Team on a wide variety of business topics and initiatives. This is a critical position on the Dematic Finance Leadership Team and will lead a group of talented executives spanning all areas of FP&A and Finance Business Partnership."  [SOFTWARE] Global VP of FP&A , 📍San Francisco, US "This is a great opportunity to lead and be a part of a high-impact team in a high-growth, publicly traded, subscription software company approaching $2B in revenue. We provide analysis to support strategic decisions, conduct financial reviews of various business areas and manage financial processes such as planning, forecasting, reporting

1940
Benji
A
Budding Pigmenteer
AhmedBBudding Pigmenteer
asked in Questions & Conversations
Measuring the size of an application

Hello here!I hope that you are well.Please, is there a way to evaluate the size of an application (like Mb for excel) or the number of calculations made in a Metrics? Sometimes, the calculations take time and I would like to know from where I can remove complexity/heaviness. Many thanks

1132
A
Budding Pigmenteer
M
Seasoned Pigmenteer
mmusabSeasoned Pigmenteer
asked in Questions & Conversations
IRR Issues

Hi Team I need to compute cell by cell XIRR . So for example, first IRR will be calculated from FY21 to FY 22, FY21 to FY 23 . them FY21 to FY24 and goes on and on. Is there a way to achieve this?  So its an expanding calc starting with FY21 and keeps on expanding by brining in additional year. ThanksMusab 

8763
Benoit
Community Manager
Benji
BenjiPigment Academic
published in Career Forum
The FP&A Jobs Report #48 (Amazon, Multiverse, Farfetch...)

For all the new joiners, a quick reminder of what you get with this newsletter:👉🏾 Around 10 fresh job offers👉🏻 From top companies worldwide👉 Every weekExecutive Positions  [RETAIL] FP&A Director,📍Plano, US "This critical position will have responsibility for the development and implementation of an enterprise level long-term value creation model, maintain and drive adherence to a corporate financial planning calendar, and provide advanced analytical and strategic support for internal and BoD meetings and communications."  [SOFTWARE] Head of FP&A ,📍Luxembourg, LU "At Amazon, we're working to be the most customer-centric company on earth. Operations is at the heart of what we do, delivering hundreds of thousands of items each day and fulfilling customer orders from all over the world. The Operations team is seeking a Head of FP&A to guide financial analysis, planning and control for a region in our fast growing Rest-of-the-World Operations Ne

1500
Benji
K
Budding Pigmenteer
Kamil SobczakBudding Pigmenteer
asked in Questions & Conversations
Adding mapping properties in the other app for existing dimension

Hey Team, I have a transaction list with all employees in the Workforce planning and in the same application we created the Employee ID with various properties mapped to this dimension like country, department etc. I would say classic Employee ID dimension block with a mapping. Now we have a need to add additional dimension property at the Employee Id level for a respective department which can be added manually employee by employee by the other team who makes the allocation of sales forces in the other application i.e. it’s not a Workforce app. What type of block we should create to have a kind of a table where we have a list of employees and then column with the list of properties for the allocation?PS. We don’t want to do it at the transaction list level due to security and also this infotramtion will never be available in our HR system to import it. Thanks! 

2144
K
Budding Pigmenteer
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
Split text

Hi Pigment team!  Is there a formula to look for the names dimension name in the Memo, and populate the EE dimension in the new property? Thanks in advance!!   

3401
Nathan
Employee
Benji
BenjiPigment Academic
published in Company News
Pigment Recognized in 2023 Gartner Cool Vendors in Capital Investment Management Software Report! ✨

We’re pleased to announce that Pigment has been recognized in the 2023 Gartner® Cool Vendors™ in Capital Investment Management Software report.   According to Gartner:“FP&A software tools often require customization to meet the life cycle of capabilities for capital investments, creating a market opportunity for emerging players. This research introduces FP&A leaders to emerging solutions with differentiated capabilities to digitalize capital investments.” Cool Vendors in Capital Investment Management Software report, 10 August 2023, Michelle Carlsen and Vaughan Archer. Read the full report here! DisclaimerGartner is a registered trademark and service mark and Cool Vendors is a registered trademark of Gartner, Inc. and/or its affiliates in the U.S. and internationally and are used herein with permission. All rights reserved. The GARTNER COOL VENDOR badge is a trademark and service mark of Gartner, Inc., and/or its affiliates, and is used herein with permission. All rights reser

4911
Yohann Bedos
Employee
A
AdamOccasional Observer
asked in Questions & Conversations
MOVINGSUM with a variable/metrics as WINDOW SIZE

Hi All, I am using MOVINGSUM which is very helpful but I stumbled on a challenge. I need to use a metrics as WINDOW SIZE rather than a fixed number. Basically the window size need to change dependently on month. I am getting the following error:Error: Function MOVINGSUM requires second argument to be a scalar integer but is defined on Dimensions '00 Hub'::MonthAm I doing sth wrongly? Is there a workaround?Regards,Adam

3495
Benoit
Community Manager
A
Just Arrived
AabhiiJust Arrived
asked in Questions & Conversations
3 Segment Cashflow Model Circular Reference

Hi, all, I am currently working on a 3 segment cashflow model within pigment. We are currently trying to model the operating cash flow but are stuck with an issue regarding a circular dependency.Within the model, we calculate cash flows (investing, operating and financing). The operating cash flows use management fees to calculate the tax paid, however the management fees are based on total assets which include cash and cash equivalents, which in turn is based on the net cash flow (derived from the combination of investing, operating and financing cash flows). This ends up with a circular reference. Our excel document avoids the circular reference by utilizing the net cash flow from the previous quarter, however doing this in pigment ends with the same circular reference  

8285
M
Seasoned Pigmenteer
K
Seasoned Pigmenteer
KevinSeasoned Pigmenteer
asked in Questions & Conversations
Using date functions with a Day dimension as an argument to the function

I have a transaction list with a date as a dimension.  This is done so that I can leverage the “delete existing items / limited scope” import functionality as the source data is purged after a 3 year rolling window.  Because the date has to be a dimension to do this, I am having difficulty creating the most basic functions on handling the date in my import.  It seems that every date function gives me an error that an argument must be of type date.  Is there a function I can use to convert the dimension into a date type (i.e., a nested function) so I can use the date functions?  I realize I could just change the field in the transaction list to date but I really want to leverage the limited scope functionality.  Any insights would be much appreciated. Kevin  

2952
K
Seasoned Pigmenteer
K
KhadijaFrequent Reader
asked in Questions & Conversations
Pigment sheet view XLOOKUP from another sheet

Dear community, I hope you are all well.Concerning the new pigment update of sheet view.How is it possible to do an XLOOKUP from another sheet? Thank you

4303
Chris
W
Weining BenKeen Learner
asked in Questions & Conversations
How to count the number of employees in different months based on the start and end times

I currently have an Employee Dimension, consisting of four columns:Employee ID | Office | Contract Start Date | Contract End DateI would like to use this to calculate the number of employees in each month, grouped by different offices, as shown in the following figure. The pseudocode would be something like: Count(Employee.EmployeeID, Date.Month > Employee.ContractStartDate && Date.Month < Employee.ContractEndDate)Do you know how to implement this calculation?Thank you in advance!

2091
Nathan
Employee
M
Seasoned Pigmenteer
mmusabSeasoned Pigmenteer
asked in Questions & Conversations
Importing Sheet View Calcs into a metric

Hi Everyone Is there a way to bring in sheet’s view calculations that we do based on existing metrics and use them in to create a metric?  ThanksMusab

2673
M
Seasoned Pigmenteer
Guillermo Puls
Budding Pigmenteer
Guillermo PulsBudding Pigmenteer
asked in Questions & Conversations
Joining 2 transaction lists into one

Hi Community: The problem: I have 2 transaction list with identical fields. I want to join them together in one single transaction list.How to do it?

2645
S
Newly Minted Pigmenteer
M
Newly Minted Pigmenteer
MattRobNewly Minted Pigmenteer
asked in Questions & Conversations
'Days in Month' Calendar

I’d like to create a metric dimensionalized by Month with a Number data format. I want each cell to contain (1) If actuals, the number of days in that month (2) if the current month, the number of days from the start of the month to the current day (3) if forecast, zero. Can anyone please advise on how to do this? I know that I will probably need an input cell with the current date since there is no equivalent of the excel TODAY function. I tried using the ‘DAYSINPERIOD’ formula but couldn't get Pigment to accept the formula / deliver a result.

3921
Fabien
Employee
K
Seasoned Pigmenteer
KevinSeasoned Pigmenteer
asked in Questions & Conversations
Limit on number of items in dimension?

I have a dimension that is over 100,000 items.  I am able to import all the items from a csv file.  However, once loaded, I can only view the first 100,000 items.  There is a menu at the bottom of the dimension list that makes it seem like I can view the next 100,000 items but it does not do anything, and I cannot view the next items past 100,000.  I want to delete the very last item, but I cannot access it.Not sure if it is related, but I have the same issue for transaction lists that are over 100,000.  I can only view the first 100,000 items.  This is problematic if I would like to edit the list or manually add an item.

2154
Nathan
Employee
M
Just Arrived
Myriem METTAJust Arrived
asked in Questions & Conversations
filtre semaine

Bonjour,Nouvelle application et nouvelle métric à créer. Je suis bloquée pour faire un filtre sur une semaine. J’ai une base de donnée où j’ai les commandes avec la semaine de passation de la commande. J’aimerai donc faire un filtre pour n’avoir que les commandes qui ont été passées avant la semaine 35 par exemple.  Comment puis-je faire ?  Merci par avance pour vos astuces ^^ 

1341
Nathan
Employee
Juhana
Employee
JuhanaEmployee
published in Company News
Oct 10-13. FP&A Week returns - and you're invited 🎉

FP&A Week: Breaking the Paradox Join us as we dive into the hard-learned lessons from top finance voices at companies like Warner Bros, Datadog, Snowflake, ClickUp, Deloitte and many others. The past years of market twists have positioned finance teams to face tough - sometimes paradoxical - questions: 🤔 How can you balance short-term targets with long-term priorities?🤔 What actionable steps have other finance teams taken to drive growth?🤔 How can you shift from number-crunching to being a strategic advisor to the business? These questions and many more will be answered at FP&A Week - ranging from building world–class teams, to fostering collaboration, and of course, AI. See the full agenda and save your virtual seat here! 

3791
Benji
A
AndrewOnuOccasional Observer
posted in Career Forum
Keyrus EPM Americas - Solution Architect

Job Description: Keyrus is seeking a collaborative and curious Principal Consultant who will design solution architecture and lead the implementation of customized Pigment applications for our customers! You will join a talented team of EPM consultants dedicated to delivery of best-in-class solutions solving for our clients’ most pressing needs. The ideal candidate will have experience designing multi-dimensional planning and analytics models to meet critical front end business user needs. Candidates must have experience leading technical project execution with a focus on Financial Planning & Analysis (FP&A), preferably with prior consulting experience. Location: Remote (New York, NY; Washington, DC; Chicago, IL Metros Preferred) Connection to Job: Hiring Manager Link: https://jobsimpetus.keyrus.us/jobs/3027800-principal-epm-consultant

1621
Benji
Benji
BenjiPigment Academic
published in Career Forum
The FP&A Jobs Report #46 (Uberall, Dyson, Coalition...)

For all the new joiners, a quick reminder of what you get with this newsletter:👉🏾 Around 10 fresh job offers👉🏻 From top companies worldwide👉 Every weekExecutive Positions  [HIGHER EDUCATION] FP&A Director,📍London, UK "The responsibilities include leading annual budgeting, forecasting, and long-range planning processes, collaborating with cross-functional teams, monitoring performance indicators, managing departmental budgets, developing financial models, driving process improvements, and delivering comprehensive financial presentations for executive and board meetings."  [MINING] FP&A Director,📍Luxembourg, LU "The role involves financial planning, forecasting, reporting, business partnership, modeling, risk assessment, team leadership, and process improvement. It involves developing and managing annual budgets, collaborating with department heads to create accurate forecasts, and analysing key financial metrics."  [MANUFACTURING] Head

1460
Benji
Benji
BenjiPigment Academic
published in Company News
Announcing our 1-on-1 Community Coffee Matching program! Join to meet your peers ☕

 Join us to meet fellow Pigment wizards 🪄 Having spoken to many members of our Community, we’ve found there’s a lack of peer support within FP&A at large. We want to play a part in bringing us all together, which is why we’re launching our new 1-on-1 Coffee Matching series! Seeing as there’s already over 1,000 of us on the Pigment Community, it’s about time we get to know each other a little bit better. Register for the program below and we’ll match you with a fellow Pigment user for a 30-min coffee get-together. ☕ 🌟 First matching happens on September 14th, so you have until then to sign up! 🌟 You can indicate if you’d wish to be matched with someone using Pigment for a similar use case as you or with someone in a particular role, and we’ll do our best to match you together with them. 👇 Register for the event below👇 

6860
Benji
Katrina
Employee
KatrinaEmployee
posted in Questions & Conversations
Income model in Pigment

Hello dear Pigment Community! 🖐Is there a Pigmenteer who’d be available to connect with another Pigmenteer to chat about the experience of doing their revops model in Pigment? 👀👂🤝An informal chat to connect with another fellow peer and share your expertise!💡Don’t hesitate to tag people you think could be up for this ! 🙌

1231
KarlW
Community Manager

Badge winners

  • Read and Interpret Formulas Certified
    mehrsharmahas earned the badge Read and Interpret Formulas Certified
  • Pigment Like a Pro
    EkaterinaGarinahas earned the badge Pigment Like a Pro
  • Innovator
    Amanda Kimhas earned the badge Innovator
  • Read and Interpret Formulas Certified
    evictoria206has earned the badge Read and Interpret Formulas Certified
  • Read and Interpret Formulas Certified
    Tom Crawfordhas earned the badge Read and Interpret Formulas Certified
Show all badges
Terms & ConditionsCookie settings