Explore the Community
Connect with other users, discuss how you're using Pigment, and get inspired
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
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
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👇
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 ! 🙌
Here’s our table for quarterly metrics. Once we close another quarter, we need to change the pages and adjust QoQ calculated items (even though they may be based on variables). What is the best way to select pages dynamically? For example, trailing 5 quarters?
Hi All, I need a simple amortization schedule by month where:Opening Balance = Closing Balance of Month -1Amortisation = e.g. 30% of Opening Balance *-1Closing Balance = Opening Balance + AmortizationI created three separate metrics but I am struggling - I am getting a circular reference when calculating Amortisation. Can you help?Regards, Adam
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 ThursdayExecutive Positions [IT SERVICES & CONSULTING] VP of FP&A 📍New York, US "Responsibilities include FP&A, operating reviews, board updates, oversight of the controllership function, and the creation of processes and dashboards to answer complex questions. Successful candidates will be collaborative, results oriented, and be able to formulate complex analyses into simple and succinct communications. This individual must be able to balance the desire to move fast, with that of providing thorough, actionable, and accurate information." [CONSUMER SERVICES] Head of FP&A 📍Paris, FR "We are seeking a Head of FP&A to manage financial planning initiatives and support growth. The role will involve developing an optimized strategy, reinforcing the existing team, and providing analytical
Join us for this session with Pigment’s education team to hear what’s brewing for the Academy, as we share what we’ve been working on to make your implementation journey as smooth as possible. Here’s your opportunity to influence the education topics that you think we should tackle. We want to hear your feedback on our courses as well as offer support on your learning journey for any tougher topics or gaps that you perceive. Academy Spotlight takes place on the 6th of September at 5pm (CET). Join us to celebrate learning! 🤓 📚 Register for the session here!
Hi AllI need to calculate Level & Trend column from actual and formula is to calculate is:Level Lt = α yt + (1 - α) (Lt-1 + Tt-1) Trend Tt = β (Lt - Lt-1) + (1 - β) (Tt-1) Here y= Actual, α & β=0.5 , L1=(y1+y2+y3)/3 andT1 = ( (y2 - y1) + (y4 - y3) ) ÷ 2 I tried to solve it by previous function & select modifier but facing circular dependency during calculation. Please help me to solve it.Sales (Actual Dt) Level (Lt) Trend(Tt) 587 605 -145 423 442 -154 805 547 -25 680 601 15 813 715 65 766 773 62
Hey,I have a dimension list with “Actual Vendors”, that are created from our actuals transaction list. I’ve created a “budget category” dimension in the “actual vendor” dimension list, where I will tag and create new budget categories for each “actual vendor”, also created a boolean column, which checks wether I tagged the “Actual Vendor” or not. I’ve also imported our Vendor Budget list, where I’ve tagged an “Actual Vendor” to each “Budget Vendor”. I know want to add/import the “Budget Category” to the Vendor Budget list, mapping it from the Actual Vendor dimension list on the aligned “Actual Vendor” dimension. I’ve tried this formula but get the error message: Error: Dimension error: the Dimensions of the formula and the current Metric structure are not compatible. Can't implicitly remove Vendor Dimension(s) on non numerical Metric.if(vendor.'Is Budget Category?',vendor.'Budget Category','FY24 Budget Dimension Vendor List - Development'.'Budget Only Vendor')]
I am modelling the flock of sheep over a period of time.The logic: 2023 sheep * lambing percentage = 2023 Lambs bornAfter one year the lambs born are added to flock of sheep. 2023 sheep + 2023 lambsThis is then multiplied by you lambing percentage to get you current year lambs births. (2023 sheep + 2023 lambs)*lambing percentage = 2024 LambsAnd this repeats for the following years.
Hi community, I have a numerical metric delivering a variance between Actual and Budget.I’m trying to create a metric (text), that transform a negative variance into a text (enabling me to add emojis there)My problem is that when I try the formula times out. What could lead to a formula time out?
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 Thursday Executive Positions [SOFTWARE] Director of Strategic Corporate Finance 📍New York, US "We are searching for a Corporate Strategic Finance leader responsible for the execution of planning, analysis, and insight into financial projections and strategic goals. You’ll marry vision, technical expertise, pragmatism, and creativity to empower others and further our use of data in key decisions. You’ll contribute to Miro’s growth and profitability by solving some of our most difficult scaling problems!" [RETAIL] VP Planning Solutions 📍Bridgewater, US "This role is critical in changing the internal ways of working to enable PVH to leverage the dynamic advances in the Planning capabilities and this individual must have proven experience in driving transformational change, global scale and positioning t
HiI’ve seen the new images widget option you launched recently. That’s great, thank you! But: how can I add images from my desktop or from my Google Drive?If I want to add e.g. our logo from our official source, I need to take the official one we have in Drive, but that URL or pasting it into my desktop, is not working. It just works with a web page in my browser (but I can’t use that one as is not with the quality I want or not coming from our official sources) Thank you!!
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 ThursdayEXECUTIVE POSITONS MANTU [BUSINESS CONSULTING] FP&A Director 📍Multiple locations, EU "You will manage business control, consolidation, cross-practice analysis, management reports, budgeting, management indicators, financial projections, corporate control, operational control, weekly sales reporting, and global controlling. You will also be responsible for EPM deployment, standard costing, and challenging and redefining management rules. Your responsibilities include managing closing processes, establishing a unified reporting system, budgeting, and implementing a global controlling approach." VISA [IT & SERVICES] FP&A Director 📍Foster City, US “This role manages the reporting and analysis of business drivers and provides insights. The Director works closely with other Finance and B
Hi Pigment team! Can you please help modifying this formula to be as following explanation? Current formula:IF(S03_IsActuals, 'DH_Data_PL EBITDA Actuals'[FILTER: 'PL GLs'."60001"], 'TT_Base Salary USD'[REMOVE SUM: Country][BY: 'PL GLs'."60001"])I would like to add “EE_Salary_USD (Actual - Forecast)” metric in the “false” section, but with prior month result. I started like below, but I am not sure what to put in the highlighted section below: Example: Thanks in advance!
Hi!I am trying to populate a column in a transaction list by using a IF-formula. I want it to say that IF the Fulfillment center name = Start Depot name, then it should be classified as a Fulfillment Center (FC), and if it is not true, it should be classified as a Dip, but I get an error saying “Expressions are incompatible and cannot all be converted to Dimension (' Hub'::'Fulfillment center')”Please see below the formula I am trying and screenshot of my expected result:IF('Act last Mile'.FULFILLMENT_CENTER='Act last Mile'.START_DEPOT_NAME,"Fulfillment Center","DIP")
Is there a way to filter both “blank” and “non-blank” FALSE boolean cells in one filter?I am trying to filter on check boxes that have not been checked, but however I filter (= FALSE, <> TRUE, etc), it still excludes “blank” boolean boxes, aka boolean boxes that have not been checked yet. Is there a way for a single filter to include both “blank” and “non-blank” FALSE check boxes?
Hi Guys, I have a beginner’s question. I am not entirely sure I understand the difference between BY and ADD. I understand both can be used to split the data into additional dimensions but not sure when I should use which. For example - I have data by Period and Account. For the purpose of dimensions alignment with other metrics, I need to add Channel and Country assuming the same values for Channel and Country per Period and Account. I know I can use BY or BY CONSTANT but what if I use ADD? What would be the difference? Regards,Adam
Hi Community,I’ve created a Commissions Forecast metric to calculate the difference between YTD Commissions and Total Target Commissions. The value is then spread over the remaining months left in the current year. I’d like to maintain the values from this metric and have it to flow through to my Total Compensation metric which has more dimensions defined in the metric structure. Any tips on how to accomplish this? Commissions Forecast Metric Dimensions: Department, MonthTotal Compensation Metric Dimensions: Department, Month, ID, Employment Type, Employment Status, Location, State.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.