Skip to main content

Explore the Community

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

778 Topics
J
Newly Minted Pigmenteer
Jessica TNewly Minted Pigmenteer
asked in Questions & Conversations
Connector: Gsheet with Pigment

Bonjour, Je voudrais savoir si ce serait possible lors d’un extract de Pigment à Google sheet via le connector de ne pas avoir des lignes vides? Ex: Lors d’un extract avec le connector, j’ai 30.000 lignes et sur ses 30.000 lignes j’ai 10.000 lignes utilent et qui contiennent des valeurs. Cela alourdi énormément les fichiers de travail.Dans les tables (extracts) dans Pigment, il y a une possibilité de filtrer et de mettre (Hide empty rows and columns). Ceci empêche d’avoir des milliers de lignes vides pas utiles.Dans l’attente d’un retour, veuillez passer une belle journée :).Cordialement.TEGUA Jessica.

1994
J
Newly Minted Pigmenteer
6 months ago
R
Newly Minted Pigmenteer
Rahul KumarNewly Minted Pigmenteer
asked in Questions & Conversations
Using Scenarios in Formula

Hello Everyone, I am working on a headcount report where in I have Actuals and Budget along with the variance.  Now I want to reference scenarios in the formulas somehow to create a metric to use this logic: If Actuals is blank and Budget is there, it means that that seat is not filled yet. Is there anyway to do it?

1824
R
Newly Minted Pigmenteer
6 months ago
Benoit
Community Manager
BenoitCommunity Manager
published in Job Board
The FP&A Jobs Report #82 (Chanel, Safran, LGC, Corndel...)

     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 weekHighlights    LGC [RESEARCH] FP&A Director 📍London, UK LGC is a leading, global life science tools company, providing mission-critical components and solutions into high-growth application areas across the human healthcare and applied market segments.    Chanel [RETAIL] International FP&A Director 📍Paris, FR Chanel is a renowned luxury fashion house known for its timeless elegance and iconic designs in haute couture.   Corndel [TRAINING] Head of FP&A 📍London, UK Corndel is a unique, multi award-winning UK management and technology training provider that focuses on delivering the highest quality programmes throughout an employee’s career.    Safran [MANUFACTURING] FP&A Director 📍Plaisir, FR Safran is a multinational aerospa

1070
Benoit
Community Manager
6 months ago
N
Budding Pigmenteer
NachoBudding Pigmenteer
posted in Questions & Conversations
Build BP from growth assumptions

I’m trying to start making hypotheses for next year's BP based on percentage growth.I started with Revenue but I find myself with the following problem that I am not able to solve.I simply want to formulate that the Revenue, for example, of January 2024 is that of January of the previous year  *  % growth. This % I have entered into a metric that I have created where I have put a % growth for each month of the year 24. However, I do not want the Revenue metrics already established in Pigment to vary or be modified, since they are the ones that give us our Revenue figures for different versions (actuals, forecast, target, etc.).Basically, what I want is to filter the information to which I want this % of growth to be applied, which in this case is only for the year 2024

3311
Nathan
Employee
6 months ago
P
Newly Minted Pigmenteer
PaylwardNewly Minted Pigmenteer
posted in Questions & Conversations
Advanced Modeling Skills

Hello,I am working on a business case where I need to take the data and create some sophisticated business items.  I want to see the forecast at different levels by who is inputting it and how to confirm the forecast is done. Here are some of the things that need to come out of the data that is provided.Alignment between top-down and bottom-up revenue targets. Consistent driver-based approach to cost planning, particularly around travel costs. Showing if forecast has been entered and how to change/override that number.Any help would be great.

841
Nathan
Employee
6 months ago
Benoit
Community Manager
BenoitCommunity Manager
published in Job Board
The FP&A Jobs Report #81 (NBC, Deliveroo, GE Vernova, Datadog...)

    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 weekHighlights    Epsilon [ADVERTISING SERVICES] FP&A Senior Director 📍London, UK Epsilon is a marketing company that specializes in data-driven strategies to help businesses better understand and engage with their target audiences.   Mews [SOFTWARE] VP of FP&A 📍New York, US Mews is a cloud-based property management system designed specifically for the hospitality industry.   NBC Universal  [ENTERTAINMENT] FP&A Director 📍New York, US NBC Universal is a major media conglomerate encompassing divisions like NBC, Universal Pictures, and various cable networks.   GE Vernova  [MANUFACTURING] Global FP&A Leader 📍Boulogne-Billancourt, FR GE Vernova is a planned purpose-built company on a mission to electrify the planet while simultaneo

900
Benoit
Community Manager
6 months ago
N
Newly Minted Pigmenteer
Not Jeremy SternNewly Minted Pigmenteer
asked in Questions & Conversations
Aggregate vs. Import for Parent/Child Dimension Relationship

We have two dimensions that have a parent/child relationship - L0 Company and L1 Parent Company. For the exercise, here are some details:L0 has 500,000 items, L1 has 400,000 items This property will be upstream of a fairly complex cohorted revenue model Both dimensions are provided to us from Snowflake The date formatted property “First ARR Date” exists at the L0 Company levelWe need First ARR Date in L1 Parent Company in Pigment, what is the preferred way to do this to maximize performance?Aggregate from L0 to L1 in Pigment using a BY MIN Aggregate in Snowflake & import the First ARR Date into both our L0 and L1 dimensions A third option?Further, would the right way to do this change if the balance of list items between lists changed?

1593
BrunoRodriguez
Employee
6 months ago
A
Budding Pigmenteer
AdamBudding Pigmenteer
asked in Questions & Conversations
Picking a dimension property dependently on scenario

Hi Pigment Experts, I have the following challenge. I have two properties in a an Employee dimension list (Department_Apr and Department_Mar). Employees may move between departments and these properties are reflecting that. Then I have a metric by Employee which I want to pivot by Department. I use the formula below and it works well. My question is is there a way to write formula so the metrics is either by Department_Apr or Department_May dependently on a Scenario i.e. dependently on input to another metric? The way it works now is that Department_Apr or Deparment_Mar are hardcoded but how to make these values a variable?  if('Is Forecast (Headcount)', '361. Total Headcount Cost - A+F') [remove: '01. Payroll Waterfall', '01. Headcount Cost Account'][select: '01. FinType'."P&L"][select: '01. Version' = 'Version Push'] //."Mar Month End"][filter: '01. Employee ID'.OperRepairs = '01. Operations/Repairs'."N"  and '01. Employee ID'.RetailTR = '01. Retail Branch / TR'."N"][by: '01. Emp

731
Mat
Employee
6 months ago
A
Seasoned Pigmenteer
AlexandreSeasoned Pigmenteer
asked in Questions & Conversations
Top Decliners / Top Growth

Hello,I have this Table with 2 differents metrics (volumes L3M and volumes L6M to L3M) with Var and Var (%) as duplicates of volumes L3M. I analyze it month by month (basically the last month). I would like to have 1 view with top Decliners on the current month (automatically done each month), i.e the doctors who have the worst Var (%) (top 20) In another view I would like exactly the same but the best Var (%) (top 20).It seems impossible to do it with table view… Can you help me please ? Thanks 

4051
BrunoRodriguez
Employee
6 months ago
Benoit
Community Manager
BenoitCommunity Manager
published in Job Board
The FP&A Jobs Report #80 (J&J, DeepL, Tide, USBank...)

   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 weekHighlights    Genmab [RESEARCH] FP&A Director 📍Princeton, US Genmab is an international biotech company committed to improving the lives of patients through innovative and differentiated antibody therapeutics.   Johnson & Johnson  [HOSPITALS & HEALTH CARE] Finance Director 📍Issy-les-Moulineaux, FR Johnson & Johnson is a multinational corporation headquartered in the United States, known for its diversified healthcare products.    Nexity  [REAL ESTATE] Contrôleur de Gestion  📍Paris, FR Nexity is a French real estate company offering a variety of services including property development, management, investment, and brokerage across residential, commercial, and corporate sectors.    Other Positions     DeepL [SOFTWARE] FP&A Manage

530
Benoit
Community Manager
6 months ago
Benoit
Community Manager
BenoitCommunity Manager
published in Announcements
✨ Congratulations to our Q1 2024 Pigment Top Modelers! ✨

Congratulations to our Q1 2024 top Pigment modelers! 🎉Every quarter we award the top 25 of our most active Pigment users with the Top Modeler Community badge 🏆We’re excited to announce the recipients for Q1 2024 as: @Tom C @connorsmith @Rahul Kumar @rachel.aumais @Brian Lese @tlegrand @CDALMAY @Weining Ben @Nicolas Houssiaux@eleger @gablahoz @Rasagya @Martin Cassan @Johan V @Gary Quirke @amelia.mejia @a2pham @Philippe @CamilleMomo @Wafae @Walid @lilyjanowski @James Dougan @ayethipathi @Jean LeeCongratulations! 2024 begins with the higher usage scores we’ve ever seen! It’s truely incredible to observe your dedication and passion for Pigment! 👍Please don’t stop here and continue to build colorful metrics and boards with Pigment!Together let’s color the FP&A world! 🎨

2543
Bill in North Carolina
Newly Minted Pigmenteer
6 months ago
D
dariousKeen Learner
asked in Questions & Conversations
Replace Blank Transaction List with Dimension

Hi Pigment Community!I am struggling with a problem and was wondering if any of you could help me solve it. The Issue: I'm working with a transaction block imported from Excel in Pigment, and unfortunately, not all the data is filled in. Specifically, I'm dealing with the Country/Region column in my All Deals transaction block. This column is dimensioned by Country Mapping, which, in turn, is connected to the Country dimension (screenshots attached for context). The snag I'm hitting is figuring out how to apply a formula that allows me to specify what information from my dimension to use when populating blank cells.The Goal: I aim to create a function in my Country/Region column that fills in blank cells with the dimension "Missing Data" for easy identification later on. The idea is to check the cell contents – if the cell is blank, I want to populate it with 'Missing Data,' sourced from my Country Mapping dimension. If the cell is not blank, I want to leave it unchanged. For instance,

5423
alexkonrad
Newly Minted Pigmenteer
6 months ago
N
Newly Minted Pigmenteer
NakulNewly Minted Pigmenteer
asked in Questions & Conversations
Closing and Opening Balance

Need help on how to pull in previous month closing balance in Opening Balance Metric. Closing Balance refers to the Opening Balance. Basically Circular Ref, and just for ref need function similar to previous of Anaplan

1212
N
Newly Minted Pigmenteer
6 months ago
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
Combine Previous(month) and BY modifier

Hi,In the below metric  with 2 dimensions Month and Version, I try to combine a Previous (Month) and a BY.For now I have the error formula is invalid.The trick  I found (please see the second screenshot) is to create a second metric “Other cash test” so I can apply BY .Thanks for your help, 

1183
Issam Moalla
Employee
6 months ago
M
Budding Pigmenteer
MKSMPBBudding Pigmenteer
asked in Questions & Conversations
How to align a property in one dimension with another dimension

Hi, I am looking to combine a transaction list (actuals) with a forecast metric using a cost centre dimension.I have the cost centre dimension in my transaction actuals but in the forecast it is a property in another dimension (property type is dimension and selected as the same one in the actuals). What function should i be using in my formula in order to bring both in combined at the cost centre level? 

772
M
Budding Pigmenteer
6 months ago
H
Newly Minted Pigmenteer
HarshilNewly Minted Pigmenteer
asked in Questions & Conversations
Show scenario variance and YoY variance in the same table

How can I show the scenario variance and YoY variance in the same table? I’d also like to be able to collapse month » quarter » year as needed. Currently, it’s showing YoY columns for all scenarios. Also, is there a way to restrict which metrics a calculated item pertains to? Lastly, is there a way to hide columns in a table? Thanks!  

1552
H
Newly Minted Pigmenteer
6 months ago
Benoit
Community Manager
BenoitCommunity Manager
published in Job Board
The FP&A Jobs Report #79 (Gusto, Chanel, Gong, Spotify...)

  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 weekHighlights    Chanel [RETAIL] Head of Corporate FP&A 📍London, UK Chanel is a private company and world leader in creating, manufacturing and distributing luxury products.   KellyDeli  [FOOD & BEVERAGE SERVICES] Head of FP&A 📍Remote, UK KellyDeli is a fast-growing, innovative food company committed to bringing the best of Asia to the world.   Qare  [HOSPITALS & HEALTH CARE] Head of FP&A 📍Levallois-Perret, FR Qare.fr is a French telemedicine platform that connects patients with healthcare professionals for remote medical consultations. Gusto  [HRTECH] Corporate Finance Manager 📍New York, NY Gusto is a modern, online people platform that helps small businesses take care of their teams.     Other Positions     Gon

1470
Benoit
Community Manager
6 months ago
K
Seasoned Pigmenteer
KevinSeasoned Pigmenteer
asked in Questions & Conversations
Chart Legend Not Displaying Bottom Center

I am unable to properly display the metric in a chart legend below the line chart.  The first screenshot has the legend in the bottom right and everything is fine.  But when I moved it to the bottom center, the second value is not displayed.  This chart is in a second view with one of the metrics hidden so perhaps that is causing the issue.  But clearly the data is being displayed as needed but without the proper legend text.  Any help to fix this would be much appreciated. 

582
K
Seasoned Pigmenteer
6 months ago
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
Amortization based on start/end dates

Hi Pigment team! I am trying to setup a amortization schedule as following. Can you please help?Orange is given resources Green is the output that I would like to have in the table/metric Blue is just validation for myself which aligns with the orange Total column and doesn’t need to be in the model   Following is the formula I used in excel:For 1/31/2023 Column alone, formula is  =($V5/$AS5)*((AV$4-$AQ5)+1) For 2/28/2023 and onwards, formula is  =IF(EOMONTH($AR264,0)<AW$4,0,IF(AW$4<=$AR264,($V264/$AS264)*(TEXT(AW$4,"d")),($V264/$AS264)))   I tried using the following formula in playground for 1/31/2023 column, but it doesn’t seem to work. IF(Month.'Start Date'=DATE(2023,01,1),('RSU Accounting Data'.'Expense Amortized Future'/'RSU Accounting Data'.'Amortization # of Days') * DAY(Month.'End Date')) Thanks for helping out!

2526
Y
Newly Minted Pigmenteer
7 months ago
C
Just Arrived
Chris EJust Arrived
asked in Questions & Conversations
NetSuite Balance Sheet - Month over Month Historical

I am trying to rebuild our Balance Sheet reporting from NetSuite into Pigment using a Saved Search. However, because our Balance Sheet is consolidated between entities that use different currencies, the Saved Search transaction amounts do not match the reported amounts in NetSuite by period. This seems to be a difference in currency exchange rate methodologies between the way the Saved Search pulls FX (by transaction) and the way the Balance Sheet report pulls FX (by reporting period). Has anyone been able to solve this and pull in historical Balance Sheets month over month to match the reporting?

2951
A
Newly Minted Pigmenteer
7 months ago
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
Exclude all the accounts starting by 5123xxxx

Hello,What formula can I use  in order to Exclude all the accounts starting by 5123xxxx ?Thanks for your help,

1118
C
Seasoned Pigmenteer
7 months ago
Benoit
Community Manager
BenoitCommunity Manager
published in Job Board
The FP&A Jobs Report #78 (Gusto, Canva, Feedzai, Geodis, Adobe, Google...)

 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 weekHighlights  Canva [SOFTWARE] Head of Corporate FP&A 📍San Francisco, US Canva is an online graphic design platform that allows users to create a wide range of visual content. Feedzai  [IT & SERVICES] FP&A Director 📍Remote, PT Feedzai is technology company specializing in fraud detection and prevention solutions for financial institutions, payment processors, and merchants.    Geodis  [TRANSPORTATION] Senior FP&A Controller 📍Levallois-Perret, FR GEODIS is a global logistics and supply chain management company headquartered in France.  Gusto  [HRTECH] Finance Operations - Pigment System Analyst 📍New York, NY Gusto is a modern, online people platform that helps small businesses take care of their teams.     Other P

690
Benoit
Community Manager
7 months ago
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
Color formatting

Hi! Is there a way I can change the color setting such that Unbilled and Billed dimensions are in different colors? Thanks in advance!!   

5475
Y
Newly Minted Pigmenteer
7 months ago
J
Just Arrived
jameslJust Arrived
asked in Questions & Conversations
Balance Sheet

Hi,I am trying to build a balance sheet in Pigment.My saved search in Netsuite lists all transactions but, to show the balance, I need to sum all of the transactions from all previous months.  How do I do this in Pigment?Alternatively, given I don’t actually need balances broken down by transaction in Pigment, would I be better off to try and find a way of extracting balances from Netsuite so that I can use those?  (though I am not sure how I do that so any idea on that gratefully received too) 

1341
Lehtohen
Budding Pigmenteer
7 months ago
KarlW
Community Manager
KarlWCommunity Manager
published in Announcements
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

2200
KarlW
Community Manager
7 months ago

Badge winners

  • Read and Interpret Formulas Certified
    Oussahas earned the badge Read and Interpret Formulas Certified
  • Read and Interpret Formulas Certified
    Alexandre Ramirezhas earned the badge Read and Interpret Formulas Certified
  • Read and Interpret Formulas Certified
    Jamilhas earned the badge Read and Interpret Formulas Certified
  • Distinguished Chatterbox
    Hugo Delabyhas earned the badge Distinguished Chatterbox
  • Autumn Top Contributor
    laurahas earned the badge Autumn Top Contributor
Show all badges
Terms & ConditionsCookie settings