Skip to main content

Explore the Community

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

941 Topics
P
Newly Minted Pigmenteer
PigmentaddictNewly Minted Pigmenteer
asked in Questions & Conversations
How to take the average division (and not a sum) in a metric when you change the pivot ?

 We are trying to make the average of all the elements of the country dimension (in rows). When we change the pivot country from rows to pages, it makes the sum of the lines and not the average. Thank you in advance for the help and the contribution to the pigment community ;)) 

7592
Nathan
Employee
A
Anonymous
published in Career Forum
FP&A Jobs #8 - 17th Nov

Executive positions1️⃣ [PROPTECH] Head of Financial Planning & Analysis @ AVIV Group, one of the world's largest digital real estate tech businesses and a subsidiary of Axel Springer.Enhance and improve our planning and performance management landscape by leveraging the power of financial and analytics systems and actively engaging with stakeholders across the group to set ambitious but achievable goals.📍 Paris, FR 2️⃣ [SAAS] Senior Director of Corporate FP&A @ Neo4j, helps organizations capture the rich context of the real world that exists in their data to solve challenges of any size and scale.This new role will lead Neo4j’s financial planning processes, including our Annual Operating Planning (AOP), quarterly forecasts and the company's long-range planning. Responsibilities also include management of the external financial reporting process, development of financial analyses models, leveraging business intelligence tools and supporting strategic initiatives.📍 Remote, US 3

1120
A
Dominick Gonzalez
Dominick GonzalezOccasional Observer
asked in Questions & Conversations
Financial Functions

Hey Team,I am working on an Existing Fixed Rate Loan walk-forward build. In the source system, the original fixed monthly payment is calculated by the following:  IF    Loan Term <> 0THEN    PMT(Interest Rate Origination Period / 12, ABS(Loan Term), ABS(LoanAcquisitionActualUPBAmt), 0, 0)ELSE    PMT(Interest Rate Origination Period / 12, Loan Term Final, ABS(LoanAcquisitionActualUPBAmt), 0, 0)Does Pigment have an equivalent function to calculate PMT? (Calculates the monthly amount required to pay back a loan given each payment is equal) Please advise - Thanks!

5241
francois
Employee
A
Anonymous
published in Career Forum
FP&A Jobs #7 - 10th Nov

Executive positions1️⃣ [AEROSPACE] Director, FP&A - Space Missions & Safety @ Virgin Galactic, an aerospace and space travel company, pioneering human spaceflight for private individuals and researchers with our advanced air and space vehicles.Create, improve, and maintain financial processes. Responsible for leading, coordinating and consolidating the business unit budgeting, forecasting, and reporting processes. Includes preparation of comprehensive business reviews and updates to Executive-level audiences.📍 Tustin, US 2️⃣ [REAL ESTATE] Head of FP&A @ Mynd, an end-to-end real estate platform that helps investors find, buy, lease, manage, and sell residential investment properties.This position plays a critical role in the development and implementation of financial, strategic and growth objectives aimed to provide long term profitable growth for the company. You must be a hands-on, roll up your sleeves type of leader and should enjoy a fast-paced, start-up environment.📍

480
A
A
Anonymous
published in Career Forum
FP&A Jobs #6 - 3rd Nov

Executive positions1️⃣ [LOGISTICS] VP Corporate FP&A @ Flexport, a platform for global logistics—empowering buyers, sellers and their logistics partners with the technology and services to grow and innovate.Lead a team with responsibilities for the annual and long term plan, forecast, and monthly reporting. In addition, you will be responsible for ad hoc analysis, executive level decks for C-level staff members, and Board of Directors reporting. In this capacity, you will lead and manage results for the P&L, balance sheet, and cash flow statements.📍 Dallas, US 2️⃣ [FINTECH] VP FP&A @ Remote, a global payroll, tax, HR and compliance solution for distributed teams.You will work closely with our CFO, CEO and senior leadership team to oversee the company’s annual budget and quarterly planning process. You’ll influence and drive strategic initiatives in partnership with our Product & Engineering, Operation and Go to Market organisations.📍 Remote, UK 3️⃣ [SPORT] Director, F

460
A
Isabella Leslie-Miller
Community Manager
Isabella Leslie-MillerCommunity Manager
posted in Company News
Congrats to our most active top modelers from Q3!

Every quarter we award our most active customers from within the Pigment app with the Top Modeler badge. Our Q3 recipients are @Josh @Eda @rschimm @Megan Richards @Rares @Alexandre @Adelgo @Anas Tahri @Yannick @Roy Stolero @Erwan @Clakss @Anthony @Yann Intes @Ifat Haham @Tanguy de Becdelievre @Sai @Marie Moisan-Plouhinec @Dastan You are all rockstars! Keep it up!

98910
Katrina
Employee
Bill Rausch
Budding Pigmenteer
Bill RauschBudding Pigmenteer
posted in Questions & Conversations
Repeating First or Last Value in Blank Periods / Use of Previous On

There have been a few instances where we need to take the fist value of a metric and have it populate earlier periods that are blank and take the last value and populate remaining blank periods.Lets assume we have a metric called Salary, with a set of values from a limited period (i.e., Mar - Jun):Jan Feb Mar Apr May Jun Jul Aug     5000 5000 5250 5250     Below is the final result we need :Jan Feb Mar Apr May Jun Jul Aug 5000 5000 5000 5000 5250 5250 5250 5250  I’ve seen the use of the previous function to populate the earlier periods:if(isnotblank(Salary), Salary, previous(Month on -rank(Month.’Start Date’))and a slightly adjusted formula to populate the later periods (i.e., take out the - in front of the rank function): if(isnotblank(Salary), Salary, previous(Month on rank(Month.’Start Date’))I’ve been unable to find documentation on how the previous function uses the on parameter.Is there another way to accomplish this or

5153
Ben A
Employee
D
Newly Minted Pigmenteer
Damián OrfanoNewly Minted Pigmenteer
asked in Questions & Conversations
Formula doesn't work (processing time without end)

I try a simple formula in a Transaction list of 91.000 items and it doesn’t get the result. It has been updating for 5 minutes, finished and the cells remained empty.  

1343
francois
Employee
I
Newly Minted Pigmenteer
Ivan SenkinNewly Minted Pigmenteer
asked in Questions & Conversations
Size of Imported CSV file

Hi, community! I have an error “This CSV size is too big. Please reach the support for more information” I cant find information about the maximum size of csv. I think it will be interesting for another members.  

2552
I
Newly Minted Pigmenteer
P
Budding Pigmenteer
PatMacBudding Pigmenteer
asked in Questions & Conversations
Spell Check

Is there a spell check function within Pigment? If so, how do I activate it and configure the settings ( UK English for example)

1091
Benoit
Community Manager
P
Budding Pigmenteer
PatMacBudding Pigmenteer
asked in Questions & Conversations
How to align values or text

How do you align values or text in a column?See below example. How would I center the values listed in the AOV column?:  

1362
P
Budding Pigmenteer
A
Anonymous
published in Career Forum
FP&A Jobs #5 - 27 Oct

Executive positions1️⃣ FEATURED 🌟 [FINTECH] VP of Finance @ Kaiko, bridge traditional and blockchain ecosystems by providing reliable and actionable financial data and services.Responsibility for investor relations, financial due diligence as well as the execution of mergers and acquisitions, company structuring as well as oversight of the finance & accounting and financial planning & analysis teams, company audits and financial operations of the organization plus tax and asset management strategy of the company.📍 Paris, FR or London, UK→ Send a note to Ambre (CEO) for a direct intro 2️⃣ [DaaS] CFO @ Inrix, help the world avoid global gridlock by empowering cities, drivers, and businesses around the globe.Responsible for the company’s worldwide Accounting, FP&A, Tax, Treasury, Investor Relations, and Audit functions, the CFO will be a key member of the company’s management team and report to the President & CEO.📍 Kirkland, US 3️⃣ [SaaS] Director, Corporate FP&A @

430
A
D
Seasoned Pigmenteer
DastanSeasoned Pigmenteer
asked in Questions & Conversations
How to automate the import of complex reports

Hi Pigment team,I am working on the report, which contains multiple columns with amounts (i.e. tax codes with its own amounts for each employee). Something like following:The issue is, when I want to import this into my Transaction List, I have to manually create 4 columns with different names (NYSD, MPEP, etc.) to capture amounts. And, this source file comes with additional columns (new Tax codes) every time, so I need to change the import settings every time to add new columns.Is there way to automatically add these column headers to, maybe dimension list, and make the system capture new amounts automatically?

912
D
Seasoned Pigmenteer
S
Newly Minted Pigmenteer
Sergio B.Newly Minted Pigmenteer
asked in Questions & Conversations
Greenhouse Integration - How to Import Target Start Date

We’ve connected Greenhouse to Pigment and aren’t sure how to import the “Target Start Date” field.We’re currently sourcing the Job data type → Open Recs, and most fields needed for workforce planning appear, but target start date is missing. Any suggestions here?

1461
Syuen
Community Manager
Dmitrii
Seasoned Pigmenteer
DmitriiSeasoned Pigmenteer
asked in Questions & Conversations
Easier way to reorder dimensions? Drag and drop maybe?

Hi everybody, It is very time-consuming to reorder dimensions with a hundreds of items. Drag-and-drop would be ideal, but it is not there or I couldn’t find it.I have a workaround of creating a `sort order` field for the dimension, but this look to hacky to me. Any tips on easier reordering?

1323
Dmitrii
Seasoned Pigmenteer
Anastasia
Employee
AnastasiaEmployee
published in Company News
Pigment NPS Survey: How we measure your satisfaction and how we make sure that your feedback helps us improve the product

You have probably heard about NPS, a survey that allows a company to measure its customers’ satisfaction. At Pigment, we care a lot about your feedback & we use the NPS survey to have more insights about your experience with the product & the company.  How do we measure the NPS? At Pigment, we send out your first NPS survey one month after your account creation, and then every 6 months after that. You will receive it via email or directly in Pigment and it will look like this:  You will be invited to provide a score from 1 to 10 and, as a follow-up, you will receive an optional question to give more details about your score. Any constructive feedback is welcome and represents an invaluable source of information to make Pigment even better!This optional survey is of great help to us!! If you prefer to opt out, simply ignore. It will disappear after several reminders. What happens after you give your feedback?Once you’ve shared your feedback, your CSM will be notified and will ha

3220
Anastasia
Employee
A
Newly Minted Pigmenteer
AdelgoNewly Minted Pigmenteer
asked in Questions & Conversations
MoM KPI

Hello,I know it is possible to create a MoM KPI, but if I add it as a KPI in a board, each month I have to change the month concerned.Is it possible to calculate automaticaly the MoM based on the last month selected in the board ? Example (picture below): In my board I selected the first 9 months of the year. For my MoM KPI, I selected september to offset with the month before. So the result is September-August. But if I select the 10 first months of the year, the KPI does not change. I expect to see automatically October-September.ThanksAdèle 

5321
Benoit
Community Manager
A
Anonymous
published in Career Forum
FP&A Jobs #4 - 20th Oct

Executive positions1️⃣ FEATURED 🌟 [B2B SaaS] VP F&A @ Intercom, the Engagement OS, enables businesses to build stronger customer relationships that drive growth and scale.Reporting to CFO Dan Griggs and based in San Francisco, the VP of FP&A will play a key role in supporting Intercom’s continued growth and path to IPO.Bring a strategic mindset combined with sound operational experience and stakeholder partnership to develop and provide insightful, value-added analysis across the company and help drive financial outcomes.📍 San Francisco, US→ If you want to know how strategic is the role to the company, well, contact for the job is Des, Founder and CEO at Intercom (des@intercom.io) 2️⃣ [B2B SaaS] Vice President, Financial Planning & Analysis @ MongoDB, the developer data platform company empowering innovators to create, transform, and disrupt industries by unleashing the power of software and data.Lead a growing and high performing global FP&A team. Create and implemen

2510
A
P
Budding Pigmenteer
PatMacBudding Pigmenteer
asked in Questions & Conversations
Unique field missing from data mapping for uploads

Should there be a “Unique” column in the below grid? If so, how do make sure that it appears at the mapping stage?: 

994
P
Budding Pigmenteer
P
Budding Pigmenteer
PatMacBudding Pigmenteer
asked in Questions & Conversations
How to unhide an item

Say I have a dimension list (“Country” for example) included in a grid (within a board) -If I hide an item, how do I unhide it If I hide an item, is there an undo function to take me back to the unhidden view? 

1704
P
Budding Pigmenteer
A
Anonymous
published in Career Forum
FP&A Jobs #3 - Oct 13

Executive positions1️⃣ [FASHION] Director of Financial Planning and Analysis @ Fox Racing, the global leader in motocross, mountain biking gear and apparel.Oversee the annual and multi-year planning process, as well as the effective use of systems and tools required for implementation and reinforcement.📍 Irvine, CA On-site 2️⃣ [MANUFACTURING] Head of Financial Planning & Analysis @ IQE, the leading global supplier of advanced semiconductor wafers.Develop the Group’s FP&A capability including the recruitment of appropriately skilled team members and the implementation of appropriate FP&A tools as part of the Group’s broader IT transformation programme📍 Newport, London, Home Other positions3️⃣ FEATURED 🌟 [FINTECH] Finance Manager @ Moonfare, a digital platform leading a new era of private equity investing.You will be the cornerstone of providing the growing business with top level local reporting, analytics and accounting support. Next to coordinating and supplying data to

1190
A
J
Seasoned Pigmenteer
Justin GrooverSeasoned Pigmenteer
asked in Questions & Conversations
Can I Apply Conditional Formatting to All Columns of a Calculated Item?

I have a budget & forecast vs actuals table as shown below.  Actual, Current Budget, and Current Forecast are Version Type dimensions that are associated with the Version dimension as properties.  The 5 columns within the red box are calculated items.  I applied conditional formatting to the variance calculated items.However, when the month changes, the formatting goes away as shown below: The intent for the above views is to associate the month dimension with an application variable of “Last Closed Actuals Month” - dynamically updating to show stakeholders their monthly and YTD variances.Is there any way to apply the conditional formatting across the entire calculated item?  Or a different approach to BvA views entirely?  The approach shown above contains 6 conditional formatting rules (3 columns x2 rules each), so doing this for every month doesn’t seem viable.  Thanks!  

2172
J
Seasoned Pigmenteer
C
Budding Pigmenteer
CBGongBudding Pigmenteer
asked in Questions & Conversations
Dimension property help

I am trying to get a formula to work showing each persons quota by quota code based on tenure. I have created a Years dimensions that outlines  year 1 = $1 year 2 = $2  ect ect with the quota value being a property in that dimension. I have then created a metric outlining each quota code by month and then plugged in the year dimension to help map how many months of what quota are needed.  All I need is to to get the below to show the number value for that year dimension listed. What is the last piece I am missing to get this to work ?  I keep getting errors. Thank you for your help!! 

1502
C
Budding Pigmenteer
J
Seasoned Pigmenteer
Justin GrooverSeasoned Pigmenteer
asked in Questions & Conversations
How to Avoid Circular References in Rollforwards

I am trying to create something in Pigment similar to the simple excel model shown below.  The key piece I cannot currently achieve is making the Churn amount be calculated as: Beginning ARR * a percentage driver.Same as above with formulas shown.  Formula works as it is cell specificWhen trying to do the equivalent in Pigment, I get a circular error.Dec 21 Ending ARR is hardcoded here for the sake of the exampleFor the sake of the example, I’m assuming Jan is actuals and Feb is forecast.  For reference, my Pigment formulas are as follows:Beginning ARR: 'Ending ARR'[select: Month-1].  I have also gotten the same result with PREVIOUS(Month)+Bookings[select: Month-1]+Churn[select: Month-1] Bookings: no formulas - direct entry Churn: attempted formula was Beginning ARR * Churn_Percent, but resulted in circular error Ending ARR: previous(Month)+Bookings+Churn Churn_Percent: Churn/'Beginning ARR'.  I allowed overrides on this metric to be used as a driver in forecast monthsIs there any work

3265
francois
Employee
J
Newly Minted Pigmenteer
JuliaSpNewly Minted Pigmenteer
asked in Questions & Conversations
IF AND OR function together

HiI need to create a formula that as multiple conditions like in the screenshot.My formule doesn’t work, can you help ?Thanks,

1882
J
Newly Minted Pigmenteer

Badge winners

  • Read and Interpret Formulas Certified
    Ghaythhas earned the badge Read and Interpret Formulas Certified
  • Read and Interpret Formulas Certified
    DiyaChatterjeehas earned the badge Read and Interpret Formulas Certified
  • Innovator
    Stefhas earned the badge Innovator
  • Read and Interpret Formulas Certified
    kimlopo23has earned the badge Read and Interpret Formulas Certified
  • Innovator
    Naomi Vriendhas earned the badge Innovator
Show all badges
Terms & ConditionsCookie settings