Explore the Community

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

727 Topics

AabhiiJust Arrived

3 Segment Cashflow Model Circular Reference

Hi, all, I am currently working on a 3 segment cashflow model within pigment. We are currently trying to model the operating cash flow but are stuck with an issue regarding a circular dependency.Within the model, we calculate cash flows (investing, operating and financing). The operating cash flows use management fees to calculate the tax paid, however the management fees are based on total assets which include cash and cash equivalents, which in turn is based on the net cash flow (derived from the combination of investing, operating and financing cash flows). This ends up with a circular reference. Our excel document avoids the circular reference by utilizing the net cash flow from the previous quarter, however doing this in pigment ends with the same circular reference

1 year ago

KevinSeasoned Pigmenteer

asked in Questions & Conversations

Using date functions with a Day dimension as an argument to the function

I have a transaction list with a date as a dimension. This is done so that I can leverage the “delete existing items / limited scope” import functionality as the source data is purged after a 3 year rolling window. Because the date has to be a dimension to do this, I am having difficulty creating the most basic functions on handling the date in my import. It seems that every date function gives me an error that an argument must be of type date. Is there a function I can use to convert the dimension into a date type (i.e., a nested function) so I can use the date functions? I realize I could just change the field in the transaction list to date but I really want to leverage the limited scope functionality. Any insights would be much appreciated. Kevin

1 year ago

KhadijaFrequent Reader

asked in Questions & Conversations

Pigment sheet view XLOOKUP from another sheet

Dear community, I hope you are all well.Concerning the new pigment update of sheet view.How is it possible to do an XLOOKUP from another sheet? Thank you

1 year ago

Weining BenSeasoned Pigmenteer

asked in Questions & Conversations

How to count the number of employees in different months based on the start and end times

I currently have an Employee Dimension, consisting of four columns:Employee ID | Office | Contract Start Date | Contract End DateI would like to use this to calculate the number of employees in each month, grouped by different offices, as shown in the following figure. The pseudocode would be something like: Count(Employee.EmployeeID, Date.Month > Employee.ContractStartDate && Date.Month < Employee.ContractEndDate)Do you know how to implement this calculation?Thank you in advance!

1 year ago

mmusabSeasoned Pigmenteer

asked in Questions & Conversations

Importing Sheet View Calcs into a metric

Hi Everyone Is there a way to bring in sheet’s view calculations that we do based on existing metrics and use them in to create a metric? ThanksMusab

1 year ago

Guillermo PulsBudding Pigmenteer

asked in Questions & Conversations

Joining 2 transaction lists into one

Hi Community: The problem: I have 2 transaction list with identical fields. I want to join them together in one single transaction list.How to do it?

1 year ago

MattRobNewly Minted Pigmenteer

asked in Questions & Conversations

'Days in Month' Calendar

I’d like to create a metric dimensionalized by Month with a Number data format. I want each cell to contain (1) If actuals, the number of days in that month (2) if the current month, the number of days from the start of the month to the current day (3) if forecast, zero. Can anyone please advise on how to do this? I know that I will probably need an input cell with the current date since there is no equivalent of the excel TODAY function. I tried using the ‘DAYSINPERIOD’ formula but couldn't get Pigment to accept the formula / deliver a result.

1 year ago

KevinSeasoned Pigmenteer

asked in Questions & Conversations

Limit on number of items in dimension?

I have a dimension that is over 100,000 items. I am able to import all the items from a csv file. However, once loaded, I can only view the first 100,000 items. There is a menu at the bottom of the dimension list that makes it seem like I can view the next 100,000 items but it does not do anything, and I cannot view the next items past 100,000. I want to delete the very last item, but I cannot access it.Not sure if it is related, but I have the same issue for transaction lists that are over 100,000. I can only view the first 100,000 items. This is problematic if I would like to edit the list or manually add an item.

1 year ago

Myriem METTAJust Arrived

asked in Questions & Conversations

filtre semaine

Bonjour,Nouvelle application et nouvelle métric à créer. Je suis bloquée pour faire un filtre sur une semaine. J’ai une base de donnée où j’ai les commandes avec la semaine de passation de la commande. J’aimerai donc faire un filtre pour n’avoir que les commandes qui ont été passées avant la semaine 35 par exemple. Comment puis-je faire ? Merci par avance pour vos astuces ^^

1 year ago

JuhanaEmployee

published in Announcements

Oct 10-13. FP&A Week returns - and you're invited 🎉

FP&A Week: Breaking the Paradox Join us as we dive into the hard-learned lessons from top finance voices at companies like Warner Bros, Datadog, Snowflake, ClickUp, Deloitte and many others. The past years of market twists have positioned finance teams to face tough - sometimes paradoxical - questions: 🤔 How can you balance short-term targets with long-term priorities?🤔 What actionable steps have other finance teams taken to drive growth?🤔 How can you shift from number-crunching to being a strategic advisor to the business? These questions and many more will be answered at FP&A Week - ranging from building world–class teams, to fostering collaboration, and of course, AI. See the full agenda and save your virtual seat here!

3021

1 year ago

AndrewOnuOccasional Observer

posted in Job Board

Keyrus EPM Americas - Solution Architect

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

1 year ago

BenjiEmployee

published in Job Board

The FP&A Jobs Report #46 (Uberall, Dyson, Coalition...)

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

820

1 year ago

BenjiEmployee

published in Announcements

Announcing our 1-on-1 Community Coffee Matching program! Join to meet your peers ☕

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👇

5250

1 year ago

KatrinaEmployee

posted in Questions & Conversations

Income model in Pigment

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 ! 🙌

1 year ago

DmitriiSeasoned Pigmenteer

asked in Questions & Conversations

How to create a report on trailing 12 months?

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?

1 year ago

M_OlivierNewly Minted Pigmenteer

asked in Questions & Conversations

Unique Property

Hello guys, I’m having a problem when trying to import this CSV file and getting this message, yet I have not used “Buyer TIN” dimension as the unique property, I used another different item as the unique property. What can I do..?

1 year ago

AdamBudding Pigmenteer

asked in Questions & Conversations

Asset Amortisation Schedule

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

1 year ago

tructranJust Arrived

asked in Questions & Conversations

At what stage do we specify the Workday report specifications to be loaded into Pigment?

At what stage do we specify the report specifications?

1 year ago

BenjiEmployee

published in Job Board

The FP&A Jobs Report #45 (AWS, Unilever, New York Times...)Jobs

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

1660

1 year ago

BenjiEmployee

published in Announcements

New Community Event: Pigment Academy Spotlight! 📚

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!

3440

1 year ago

abhilashsawlaPigment Academic

asked in Questions & Conversations

How to solve Circular dependency

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

1 year ago

JAdrianNewly Minted Pigmenteer

asked in Questions & Conversations

Importing a dimension from one dimension list to another

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')]

1 year ago

Angus RobertsonNewly Minted Pigmenteer

asked in Questions & Conversations

Inventory of Animals.

I am trying to model the age of sheep over years. The closing balance of a 1 year old sheep becomes the opening balance of 2 year old sheep the following year. The closing balance of 2 year old sheep becomes the opening balance of 3 year old sheep the following year. And so on.

1 year ago

Angus RobertsonNewly Minted Pigmenteer

asked in Questions & Conversations

Inventory of animals - possible circular reference.

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.

1 year ago

Guillermo PulsBudding Pigmenteer

asked in Questions & Conversations

Emojis in dimension to define status

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?

1 year ago

Page 15 / 30

Explore the Community

Badge winners

Sign up

Single Sign-On Need help?

Log into the Pigment Community

Single Sign-On Need help?

Scanning file for viruses.

This file cannot be downloaded