Skip to main content

Explore the Community

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

967 Topics
A
AdamOccasional Observer
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

5633
A
T
Just Arrived
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?   

1681
Benoit
Community Manager
Benji
BenjiPigment Academic
published in Career Forum
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

1750
Benji
Benji
BenjiPigment Academic
published in Company News
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!

3630
Benji
abhilashsawla
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

3761
Benoit
Community Manager
J
Newly Minted Pigmenteer
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')] 

2442
J
Newly Minted Pigmenteer
A
Newly Minted Pigmenteer
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.  

2956
Benoit
Community Manager
A
Newly Minted Pigmenteer
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.   

1271
Benoit
Community Manager
Guillermo Puls
Budding Pigmenteer
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?  

1421
Benoit
Community Manager
Benji
BenjiPigment Academic
published in Career Forum
The FP&A Jobs Report #44 (Miro, PVH, Deliveroo, Carta...)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 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

750
Benji
M
Seasoned Pigmenteer
mmusabSeasoned Pigmenteer
asked in Questions & Conversations
Sheet View Questions

How can i add sheet view as a default on board ?And secondly if we make manual calculations on sheet view , how will they flow through?

1871
Gabriel Amaro da Luz
Employee
Benji
BenjiPigment Academic
published in Career Forum
The FP&A Jobs Report #43 (Visa, GAP, Pigment 👀...)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 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

3430
Benji
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
Add prior month result

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!

3431
Issam Moalla
Employee
I
Newly Minted Pigmenteer
IsabelNewly Minted Pigmenteer
asked in Questions & Conversations
IF function in transaction list

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 ('[00] 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")  

5962
I
Newly Minted Pigmenteer
Jeremy Stern
Newly Minted Pigmenteer
Jeremy SternNewly Minted Pigmenteer
asked in Questions & Conversations
Filter Excluding Blank Booleans

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?

7313
Benji
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
Can we use FORECAST_ETS function for holt & holtwinter forcasting?

hi allCan we use FORECAST_ETS function for holt and holtwinter forcasting calculation?if yes than How?

4541
Keiran
Community Manager
Kyla
Budding Pigmenteer
KylaBudding Pigmenteer
asked in Questions & Conversations
Aligning dimensionality across metrics

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. 

4192
Kyla
Budding Pigmenteer
L
Newly Minted Pigmenteer
Lester ChowNewly Minted Pigmenteer
asked in Questions & Conversations
Select specific months

How do I select the first 3 months of each FY?For ex: Revenue [SELECT: Month.Quarter] gets me the revenue for each quarter. but now I want just Q1 in each FY. How do I do that?

5961
abhilashsawla
M
Seasoned Pigmenteer
mmusabSeasoned Pigmenteer
asked in Questions & Conversations
Rolling Average

Hi I have a CPI metric which starts from FY2022-23 and goes on till FY 2121-22. I want to create a rolling average of first 25 values starting from FY2022-23 including FY2022-23 plus next 24 years.Then when it comes to FY2023-24, it does the same thing and include FY2023-24 and the next 24 years. and goes on and on. ThanksMusab

7344
M
Seasoned Pigmenteer
KarlW
Community Manager
KarlWCommunity Manager
published in Career Forum
The FP&A Jobs Report #42jobs

For all the new joiners, a quick reminder of what you get with this newsletter which is sent every Thursday:The 10 most recent job offers from companies worldwide Hand-picked upcoming FP&A events Finds of the Week Subscribe to the FP&A Report here Executive positions Ramp [FINANCIAL SERVICES] FP&A Director 📍NY/ Miami / Remote, US "This role will be responsible for overseeing the company’s growing FP&A function, ensuring we deeply understand our performance, building comprehensive reporting for internal and external stakeholders, and surfacing critical insights to inform intelligent capital allocation decisions across the business. You’ll have regular exposure to numerous cross-functional partners, Ramp’s leadership team, and our investor community." StanleyBlack&Decker [MANUFACTURER]   FP&A Director  📍Miramar / Remote, US "As a Director, FP&A ~ LAG, you will lead the FP&A team for the $830 million LAG business, reporting t

3140
KarlW
Community Manager
T
Newly Minted Pigmenteer
TWestNewly Minted Pigmenteer
asked in Questions & Conversations
Dimension Property

I’m trying to map one dimension in my transaction list to another using the lastnotblank function: ‘Pigment Dealer Model’ is the transaction list and ‘Dealer Type’ and ‘Dealership Id’ are both list properties; sometimes when I use the lastnonblank function it will work and other times, I get the error below: Is there a reason this function would be working sometimes, and not other times? When it works it produces this:  Any help would be much appreciated and please feel free to ask for more detail if needed. 

5602
T
Newly Minted Pigmenteer
Guillermo Puls
Budding Pigmenteer
Guillermo PulsBudding Pigmenteer
asked in Questions & Conversations
Modifying Month dimension in Calendar

Hello Pigment community, Quick one here. I want to modify the Month Dimension in my calendar but “Cannot update a protected property (eg. built-in properties of calendar dimensions)”I’m currently showing Jun 23 (MMM YY) and would like to switch to Jun-23 (MMM-YY).How can I tune my own Calendar?Thanks in advance !!Guillermo

4433
abhilashsawla
M
Just Arrived
Myriem METTAJust Arrived
asked in Questions & Conversations
Fonction pour avoir la valeur des mois suivants

Bonjour,J’aimerai avoir la donnée des mois suivants. J’ai une donnée par mois et j’aimerais calculer une donnée dépendante des 3 mois suivants.  Merci par avance.  Par exemple : 1 257 k€ est la somme des mois de décembre à Février.  

5471
Issam Moalla
Employee
N
Budding Pigmenteer
NachoBudding Pigmenteer
asked in Questions & Conversations
YTD column

Hi!I’m trying to create a new column with YTD figures in a table where we see EBITDA by market.The logic we’re trying to find is to be able to tell Pigment that this column has to be the sum of the actual months and to group it all in a single column.  That is to say, it would be something similar to a filtering option, just as we can filter by month to see the info for a specific month, so that we can choose to see only the YTD figures.The idea is that it would be something dynamic and as we close new months that become current months Pigment would understand that the YTD info has to be updated.

6203
Benoit
Community Manager
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
how we can limit the user for input value?

Hi Community Members,Please let me know how we can limit the user for input value.Means, There is an input metric where user can provide input between 0.01 to 0.99 only.

6719
abhilashsawla

Badge winners

  • Partner Solution Consultant Certified
    YounesZhas earned the badge Partner Solution Consultant Certified
  • Pigment Modeling Fundamentals Certified
    Alexxyuhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    Alexxyuhas earned the badge Pigment Like a Pro
  • Read and Interpret Formulas Certified
    Ben Essalamahas earned the badge Read and Interpret Formulas Certified
  • Pigment Modeling Fundamentals Certified
    Nancy S.has earned the badge Pigment Modeling Fundamentals Certified
Show all badges
Terms & ConditionsCookie settings