Explore the Community

I am attempting to import data from Looker via webhook but am receiving a CSV Format & Mapping error each time. I have the saved import configuration ID correct in the webhook address, but when importing, it seems like Pigment does not recognize the column headers. I was careful to import the same exact CSV when setting up the configuration, it should have the same headers. Would anyone be able to advise on this?  

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 Roles [STAFFING & RECRUITING] Head of FP&A 📍Multiple locations, UK Energy Jobline is the largest and fastest growing global Energy Job Board and Energy Hub.  [MANUFACTURING] FP&A Director 📍DK / UK / DE LEGO is a Danish toy company widely recognised for its interlocking plastic bricks and sets.  [FINANCIAL SERVICES] FP&A Director 📍Atlanta, US FLEETCOR Technologies is a leading global corporate payments company providing innovative solutions.   [MANUFACTURING] FP&A Director 📍St Gallen, CH VAT Group specialises in the design and manufacturing of high-vacuum valves and vacuum solutions.  Hiring? Submit a job!Other Roles [IT & INTERNET] Senior FP&A Analyst 📍London, UK Global Fashion Group is a multinational online fashion ret

Hello, this new feature, I’ve tried it in one of the apps in which I’m a security admin, but it is not working, I have the message I send attached Could you please help? Thanks!!    

Hello there! Is there any functionality to edit display names of Scenarios in Pigment? (Or any work arounds)Here is the situation: I’m working on a BvA (comparing Actuals vs. Plan). In order to show my Actuals data I am using the “Current Forecast” scenario (because the Current Forecast scenario always has the latest and greatest actuals). However, when I put the BvA together the title of the scenario is “Current Forecast” and I don’t see any way to change it to “Actuals”Questions:1) Is there functionality to edit display names of Scenarios in Pigment?2) Is it general best practice to have a “Actuals” scenario (fully dedicated to only showing Actuals data)  

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 [STAFFING & RECRUITING] Head of FP&A 📍London, UK Goodman Masson is a recruitment and consulting firm specialising in financial recruitment, providing services in areas such as accounting, finance, technology, and change management across various industries and sectors.  [MANUFACTURING] FP&A Director 📍Grenoble, FR ARaymond Network is a global industrial company known for its expertise in fastening and assembly solutions.   [FINANCIAL SERVICES] Head of Strategic Finance 📍New York, US Flex is an early-stage, remote-first FinTech startup that is creating the best rent payment experience.  Hiring? Submit a job!Other Positions [INSURANCE] FP&A Analyst 📍London, UK Direct Line Group offers a range of general insurance products, including car, hom

It seems that Transaction List do not have Pivot possibility? Is it still possible and I can’t find it or do I need to create a Table from that Transaction list and Pivot it there?

 2023 was our second full year of operation, and a landmark year for the Pigment Community. Here’s a few numbers to show what we all got up to:🫂 We welcomed over 900 new members✉️ We had over 2,000 posts and replies❓ We answered over 230 of your questions🛠️ 50 Community Ideas were launched in Pigment Needless to say, none of this would’ve been possible without having such fantastic Community members – a sincere thank you to each and every one of you on here. As our Community member @Zane put it in our recent December Community Spotlight interview, “There are no stupid questions!”. Keep them coming – we’re beyond excited for another year of learning and collaborating in 2024. We also want to give a shoutout to our top 5 most active Pigment modelers of 2023 ✨ You all pretty much have Pigment PhDs at this point… Maybe we should print out diplomas?🎓 @Emilia 🎓 @rschimm 🎓  @David S 🎓 @Eda 🎓 @Stephen  While we’re on a roll here, special thank you to some of our own Pigment Community ch

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  [FINANCIAL SERVICES] VP of FP&A 📍New York, US SMFG is a Japanese financial services company that operates as a holding company for various subsidiaries.   [IT SERVICES & CONSULTING] FP&A Director 📍New York, US CGS is a global provider of information technology services, outsourcing solutions, and software that supports various industries in business process outsourcing, IT consulting, and enterprise software applications.   [FINANCIAL SERVICES] Assistant FP&A Director  📍 London, UK IQ-EQ is a global provider of investor services and fund administration.   [BANKING] Contrôleur(euse) de Gestion 📍Nanterre, FR Societe Generale is one of the leading European financial services groups.   Hiring? Submit a job!Other Positions  [MANUFACTURING

I have a formula on my data load table, which automatically attributes a ‘clean’ code to an uploaded busline code. For eg. If a country NG uses XXXNOTALLOC , the clean code attributed to it is XXXNOTALOCNGThe formula is the following : if(('Actuals P&L Data Load'.'Busline Code - Warehouse' = Busline."LOCCENTRALTN" or 'Actuals P&L Data Load'.'Busline Code - Warehouse' = Busline."LOCCENTRAL")and 'Actuals P&L Data Load'.id_company='Legal Entity'."JT_TN",Busline."LOCCENTRALTNSSC", if('Actuals P&L Data Load'.'Busline Code - Warehouse' = Busline."LOCCENTRAL" or 'Actuals P&L Data Load'.'Busline Code - Warehouse'.'is not alloc',ifblank(item('Actuals P&L Data Load'.'Busline Code - Warehouse'.'Original - Busline'& 'Actuals P&L Data Load'.'Company Country - Warehouse'.Code,Busline),'Actuals P&L Data Load'.'Busline Code - Warehouse'), 'Actuals P&L Data Load'.'Busline Code - Warehouse'))I dont want this to happen, I want to code to stay at XXNOTALLOC. I am no

We have the Snowflake connector already set up to bring data into Pigment, however we’re now looking to export data from Pigment back into Snowflake for reporting. I’m wondering if this is possible to automate (I didn’t see any Pigment->Snowflake functionality mentioned here) - ideally I can set up a table with a few metrics that is exported to Snowflake monthly. Thanks in advance!

 We’ve just announced findings from a Total Economic Impact™ (TEI) study, conducted by Forrester Consulting and commissioned by Pigment.  The TEI demonstrated Pigment’s substantial ROI for a composite organization representative of interviewed customers, 306%, including over $8.1 million in benefits over a three-year period and more than 1,000 hours saved per year across Finance, Sales and Supply Chain planning. Here’s where you’re making productivity gains:Financial planning and analysis130 hours per analyst yearly, 480 hours per FTE within the payroll team and 84 hours per executive.Sales planning619 hours of work per analyst and 201 hours of work per sales planner.Business forecasting20 hours per analyst per forecasting cycle and 16 hours per executive.Scenario planning12 hours per analyst during the 10 scenarios and six hours per executive at each of the four scenario planning reviews per year. Read the full study here. 

Hello, I have a dimension list with 1 column where all items are in the following format: XYZ or XY/ABC.  I would like to add now a second column that will have 2 possible values: Product A or Product B (TEXT). -If you detect a “/” in the cell, please say Product A-If not, please say Product BI believe it is a variation of using if contains/mid.. however, I do not find the right formula. Would it be possible to help? Thank you very much! 

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] Head of FP&A 📍London, UK Ted Baker is a British luxury fashion brand known for its distinctive blend of quirky yet sophisticated clothing, accessories, and lifestyle products.   [MANUFACTURING] FP&A Director 📍Haag, CH VAT Group is specialising in the design and manufacturing of high-vacuum valves, vacuum components, and solutions for various industrial applications.   [ADVERTISING SERVICES] Corporate FP&A Director 📍EMEA / US Criteo is the global commerce media company that enables marketers and media owners to drive better commerce outcomes.  Hiring? Submit a job!Other Positions   [SOFTWARE] Senior Financial Analyst 📍Remote, US DigitalOcean simplifies cloud computing so developers and businesses can spend more time building softwar

Hello everyone,I have created a metric to retrieve the current version i am working on, and it is based on my dimension Version. But when I try to retrive it in other blocks (like in a transaction list) I have this error : Dimension error: the Dimensions of the formula and the current Metric structure are not compatible. Can't implicitly remove Version Dimension(s) on non numerical Metric. how can I solve this issue?Thanks in advanceNada

Hello everyone,Could you please tell me if we can easily implement parallel hierarchies or not?Thanks 😀

Hello,I have a transaction list with month, employee, role and value like this : Month Employee Role Value oct-23 1000 RA 12 nov-23 1000 RA 23 dec-23 1000 RA 12 oct-23 1001 RB 34 nov-23 1001 RB 32 dec-23 1001 RB 21 oct-23 1002 RA 45 nov-23 1002 RA 67 dec-23 1002 RB 54 oct-23 1003 RB 32 Each column (whitout value) is connected to a dimension. I would like to have the max of a value by role but I would like to can change the month.Ex : If I select no month in the table(or all), I would like to see : RA 67 RB 54   And if I select nov-23 : RA 67 RB 32  Same things if I select oct-23 and nov-23 : R

Is there existing functionality to facilitate the filtering of a dimension input metric, say on a Department dimension, whereby subsequent selections would then be filtered based on only valid intersections that apply?  I currently have two input metrics, one by dimension Department and the other by dimension Position.  Is there a way that when the selection is made for Department, say “Accounting”, only the relevant Job Positions are now available within that dimension drop-down, so that something like Job Position “Legal Analyst” isn’t a viable option?

Hi Pigment Community, We have a dimension list that generates unique IDs for potential hires before they go through our formal requisition process. Curious to know:1.  Is there a way to customize unique IDs so they follow a specific nomenclature (i.e. TBH - 001)? Would concatenating them be the best approach? 2.  Is it possible to generate unique IDs based on a dimension? For example, if we created a “to-be-hired” role under Department A, it would generate unique ID #1. If we created a “to-be-hired” role under Department B, it would generate unique ID #2 since unique ID #1 is already in use elsewhere. Currently, both roles are tied to unique ID #1. Ideally, we would want to associate properties to these unique IDs as well.

Dears, I am trying to filter by the current month in each of the metrics, I would use TODAY() function in excel, but since there is no function like that on Pigment. As a workaround I created a metric that I called Current Date (Month Dimension) , which I will update monthly, so that I can filter by that metric and automatically update all the other metrics. IF('MRR Be Churn Analysis'=1,TRUE)[FILTER:'Data Hub'::Month='Current Date'] However, I did not work, do you have any suggestion or guidance? Thank you very much in advance! Jose

Hi!If I have this info in several rows, as a list of transactions:One column with the amount in a local currency One column with the amount in EUR One column which tells me the month of the transactionHow can I calculate the FX rates per month, as a weighted average (not the simple average, but the average taking into account the weight of each transaction in the total amount of that month)?Sorry maybe is so obvious how to do it, but I don’t know, I know how to do it exporting the transaction list and calculating it in the file but...not sure how to calculate it directly in Pigment, which is what I would like to do better. Thank you!

Hi Team,We have been trying to figure out how to visualize and separate actuals and forecast data when sharing rolling forecast scenarios with budget owners and other users, mainly because non-FP&A users are not familiar with the switchover date workflow. We bring this up because the period type is a cross scenario setting, and we set different switchover dates for different scenarios so it won’t help.What’s the best practice? Roy and the rest from Melio :)

I want to make a welcome message for my dashboard but I want it to be big enough to be used on my dashboard.Any help would be appreciated.This is how it looks like right now. 

Hello Pigment Community, I want to have a metric that has clients in lines and months in columns and that is filled with 1 only for the first month the client bought a thing. So in the end, on each line there should be only one 1 in the month of the first buy. For the moment I created a metric with clients in line and months in columns that is filled with 1 for all the months when the client bought a thing. My idea was to use this metric and the firstnonblank modifier but it does not work… Could you help me please ? 

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 week [CONSUMER SERVICES] Head of FP&A 📍Copenhagen, DK HelloFresh is a consumer services company that revolutionises the way people eat by providing meal kit delivery services.   [RETAIL] FP&A Director 📍Vianen, NL Foot Locker is a global retail company specialising in athletic footwear and sportswear.  [ADVERTISING SERVICES] FP&A Director 📍 Paris, FR Criteo is a global technology company specialising in digital advertising, particularly in performance marketing and personalised retargeting solutions for e-commerce businesses.  [FINANCIAL SERVICES] VP of Strategic Finance 📍Paris, FR Qonto is a French online payment institution for freelancers and SMEs.  Hiring? Submit a job!FP&A Manager 📍Bruxelles, BE Campari Group is an Italian beverage company know

Hi Pigment Community,I am reaching out to bring attention to an issue I've been encountering with Pigment, particularly in relation to the mathematical output it provides. While Pigment generally performs as expected, I have noticed instances where the results are unexpectedly incorrect.To provide clarity, I have attached screenshots displaying the metrics and their corresponding outcomes. I've highlighted the specific instances where Pigment has generated results that deviate from the anticipated values. It's worth noting that there are occurrences where the formula yields accurate results, but the inconsistency raises concerns about best practices and how formulas work. My hope is that you can help me understand the root cause of this issue and provide insights to correct this issue. I appreciate any assistance you can provide in shedding light on why Pigment might be producing these unexpected results. Additionally, I am keen to learn any best practices or recommendations to avoid s