Explore the Community

Executive positions1️⃣ [FINTECH] Head of Financial Planning Analysis @ Moneyfarm, an online investment advisor and one of the largest digital wealth management companies in Europe.Lead end-to-end planning, budgeting, forecasting and reporting cycles, preparing timely and accurate information and insights to the CFO & Exco. Build strong working relationships with corporate controllership and collaborate to deliver structured, high quality accurate financial reporting on the basis of streamlined processes.📍 Milan, IT 2️⃣ [MANUFACTURING] Head of Financial Planning and Analysis @ Dyson, designs and manufactures household appliances such as air purifiers and hand dryers.you will own the delivery of accurate, timely and insight

Hello,I want to use a vlookup on a non-dimension column. Is it possible ?Exemple : Dimension A : I have those 2 columns : I want to retrieve the Manager via the e-mailDimension B : I have my e-mails and my managers. Question : How can I get my managers in Dimension A ?Thank you :)

 Is there a way to delete users instead of just deactivating? I don’t see an option as primary owner.  Related: I believe currently transfer application can only be done by current owner, can the workspace owner transfer application ownership?  

Hello community, I’m trying to populate the very last column of the below Transaction list, which is set as dimension, which is already defined. I could populate the column line by line by selecting the values from the dropdown but there are lots of lines.  That’s why I’m trying to use a formula to populate the dimension via formula.The formula should bring the text from the Entity column (set as a dimension) and concatenate with the result with an if statement aiming to provide “Account code” text column (circled) in case it’s’ populated, or in case “Account code” is blank provide the “Account name” text column (highlighted in blue)if (Transactionlist.AccountCode = “”,Transactionlist.AccountName,Transactionlist.Accountcode) The result should be: Entityname2202 or EntitynameBank

Is there a way to create a metric that joins/appends values from two separate transaction lists? List 1 would for example be most popular colour by product and month in 2022 and List 2 would have most popular colour by product and month in 2023. In my metric I want to join the two into a single metric.The values are dimensions, i.e. not amounts. Using a + works when working with amountsList1.Quantity[by lastnonblank: List1.ProductID, List1.Month]+List2.Quantity[by lastnonblank: List2.ProductID, List2.Month]but doing this with dimensions gives me an error:Error: Arithmetic operators only accepts same type arithmetic inputs after implicit casting, received Dimension (Competence) operandsThe reason I’m not using the same list for everything is due to List 2 having additional data that wasn’t available when we built the original model, and it having an automated import. And I’m tryi

Congratulations to our top Community contributors of 2022! 😀We value every single one of our Community users, however we would like to take this opportunity to say a massive THANK YOU to these users in particular who have really helped drive activity and conversations on our platform. Our Community has only been live for about a year, and without you, it would not be where it is today. @Sofia Costa @CamilleMomo @Roy Stolero @rschimm @Alexandre @MKohli @Dastan @Adelgo @agnar @Megan Richards @Jose 

Hello community!I want to create a simulation tab to test several employee cost before hiring someone. Concretely, I want to create this knowing that company is a dimension, fix and var are manual inputs, currency is a dimension and total gross will be a formula according to what have been entered in company, fix, variable and currency. Thanks a lot! 

Join me in congratulating @Keiran, @markdeprez, @Jake, @CamilleMomo, and @Tess.Hunt on becoming our newest additions to the Modeling Fundamentals Certified club! 🥳🥳🥳 Interested in earning that badge for yourself? Check out the certification quiz on Pigment Academy for all the details.

I’m wanting to add some list items I generate based on a formula into a dimension list automatically.The Item function allows us to search and return a dimension if it exist in a list but I’m wondering how instead of returning BLANK I would be able to automatically add a missing item into the dimension.Some context: Pulling data from multiple sources which may have the same Primary Key therefore in Pigment I would like to Concatenate the Data Source Name to the ID and add it into a Global dimension we maintain.Ex.Global Dimension is IDsData Source 1 IDs1 2 3 4Data Source 2 IDs2 4 Processing I would like to do in pigment is to add Data Source 1 and 2 IDs to the global dimension so the output would be:DS1-1 DS1-2 DS1-3 DS1-4 DS2-2 DS2-4

Hello,I would like to know if you have a best practice to share regarding the recruitment plan.At first we have a line for a recruitment to be done. Once the recruitment is completed, we have the name of a future employee. How do you keep track of that and follow this in the most automated way ? (to avoid duplicates on the actuals and forecast)Thank you :)

Quick question:Is there any option to add our Corporate Logo to the Boards?Thanks

Executive positions1️⃣ [SAAS] Head of FP&A @ mParticle, a customer data platform for every screen, built with Privacy by Design.Partner with and build strong relationships with business partners across the organization; working closely to develop and translate financial forecasts and operational metrics into actionable guidance that assists with decision making. Proactively identify areas for business improvement and produce persuasive, data-driven arguments to support good decisions.📍 Remote, New York, Seattle, San Francisco, US 2️⃣ [SAAS] VP, Finance - Financial Planning & Analysis @ PagerDuty, a cloud computing company specializing in a SaaS incident response platform for IT departments.

Executive positions1️⃣ [SAAS] VP of Strategic Finance and FP&A @ Choco, the largest free ordering platform connecting restaurants and their suppliers.As VP of Strategic Finance and FP&A, you will take on and build out strategic analysis across multiple product lines, geographies, monetisation initiatives and competitive landscapes. You will report directly to the CFO with very high visibility across the organization. 📍 Berlin, DE 2️⃣ [LUXURY] Senior Director, Financial Planning + Analysis @Louis Vuitton, a French high-end luxury fashion house.You will play a critical role in the development and implementation of financial, strategic and growth objectives aimed to provide long term profitable growth for the com

Hey everyone! I’m trying to create a cohort framework in the backend of the model. To do this, I’m using my Datahub::Month dimension and my Revenue app::Cohort Months dimension. It should generate something like:                    0             1             2Jan 23    Jan 23     Feb 23    Mar 23Feb 23   Feb 23     Mar 23    Apr 23Mar 23   Mar 23     Apr 23    May 23 and so on. Is this the best practice to enable cohort logic for things like churn? To create my Cohort Months dimension, I can manually type integers 0 through 60 for example, but is there a way to use PREVIOUS() to just increment 1 each row to do this? Screenshot:  

Executive positions1️⃣ [SAAS] Director of Financial Planning and Analysis @ Superside, an always-on design company that delivers great design at scale to Enterprise teams.Reporting to the CFO, you will lead a team that supports the long-term strategic planning of Superside and helps all of our business areas with financial analysis & planning.📍 Fully remote 2️⃣ [BIOTECH] Director, Financial Planning & Analysis - Customer @ Sarepta Therapeutics, a medical research and drug development company.The Director, Financial Planning & Analysis (FP&A) serves as the lead partner between Finance and the Sarepta Customer Organization. This position provides critical financial input for strategic and operational business decisions and proc

Hello Pigment Community!I would like to delete an item in a Dimension (which has been created by an error in the settings when importing data), but because this Dimension is used by several blocks, I don’t want to delete data in these other blocks. Could you please help me to find a way to see if said item is used by other blocks and if I can simply delete the line containing the wrong item in the Dimension?Thank you! 😊

Executive positions1️⃣ [FINTECH] Director, GTM FP&A @ Human Interest, levels the playing field on retirement by making employer and employee retirement savings more intuitive, more affordable, and more inclusive.Be the FP&A lead supporting our Revenue teams, own financial and headcount planning, performance reporting, and be the primary finance partner to the CRO. Lead the monthly, quarterly, and annual FP&A processes for the Revenue organization, including management reporting, variance analysis, forecasting, and scenario planning.📍 Remote, US 2️⃣ [B2B SaaS] Vice President, FP&A

Hello Team,Is there a way to reference an object(from a transaction list) within a metric without having it auto aggregate? See screenshots for reference.  

 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 ;)) 

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 f

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,

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,

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 an

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 

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