Explore the Community

Hi Pigmenteers! When reading Top Tips for modeling in Pigment - Part 2: Performance Optimisation, there’s an idea as highlighted in the screenshot below: to avoid doing too much within one metric, there’s “a good guideline is that, if you have to copy and paste part of a formula more than once, it may be worth its own metric” - I don’t quite get it, can you help explain this idea to me?  

Hello,I need to create a form for end users to assign  a cross-dimension (direction and activity) to 2 new dimensions (Analytical Dim level 1 and Analytical Dim level 2). To do this, I was thinking of:Creating a table with the direction/activity cross and the associated data. Creating 2 metrics with the direction and activity dimensions A. to select: Analytical Dim level 1 B. to select: Analytical Dim level 2However, I would like the selection of "Analytical Dim level 1" to only display the child items of Analytical Dim level 2. Is it possible to do this and if so, how?Thank you in advance for your help.

Could someone please help let me know if I could have my calculation shown in points vs bps? Thank you

Hi everyone, I am trying to display images in my reports but i get this error message “The image couldn’t be displayed” The link is working when pasting it in the browser, and the source is authorized Here is the link of the Image i would like to display : https://drive.usercontent.google.com/download?id=1P7ssJsoxLzsQjkGdRf_b4EFTYvIbAQmr&authuser=0 Thank you in advance for your help

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 [SOFTWARE] FP&A Director 📍Remote, US Gong is a revenue intelligence platform that utilizes artificial intelligence to analyse sales interactions, providing insights and recommendations to improve sales effectiveness and drive revenue growth for businesses.  [SOFTWARE] Head of FP&A  📍San Francisco, US Canva is a global online visual communications platform on a mission to empower the world to design.  Senior FP&A Controller 📍Levallois-Perret, FR GEODIS is a leading global logistics provider acknowledged for its expertise across all aspects of the supply chain. VP of Strategic Finance 📍Paris, FR Qonto is a French fintech company that provides online business banking services, offering business bank accounts, corporate cards, and financial management to

Hi, I’m trying to add a view of a monthly total headcount metric (a cumulative value, dimensioned by month) to quarterly and annual tables that will show only the final headcount from the last month of each period. For example, I know Pigment’s default behavior is to sum this cumulative headcount across every month of a year if I add the headcount metric to an annual table directly, but I need to isolate December 31 headcount only. Is there a relatively simple way to create these period-end summary numbers?Thanks!

Hey there,I’m trying to use yesterday’s revenue to forecast the rest of the month’s revenue.For that, we created a Day dimension, which is a calendar type.Strangely, when displayed in the dimension itself, it looks normal (like a date).However, when we add it to a metric pivot it always adds the time. How do we stop it from doing this?I’ve already checked the Day dimension Special Properties and Default Display Name and it just uses the Name column for this.Images below.Any help is much appreciated! Day dimensionDay dimension used in a metric pivot 

Hello,I am trying to calculate the number of employees who left by hire date cohort and number of months that they stayed in the society. Here is the formula I have (but doesn’t work because it is too complicated I think):Employee [BY COUNT: Employee.'Cohort Month', Employee.'Month tenure cohort', Employee.Country, Employee.'First Job Position'.'Team Graph HR']The Cohort month corresponds to the month of arrival.The Month tenure cohort corresponds to the number of months the employee stayed in the society.I want this metric by team department (Team Graph HR) of their first job position (because some employees can evolve from one job to another in the company).Could you please help me finding the best formula here?Thanks!Elodie

Curious to know if there any 1st or 3rd party connectors to get capiq data directly in pigment automatically.It’s not too difficult to upload a CSV on a monthly cadence, but would be great if there was a live connection. The alternative is to send this to an internal DWH then to Pigment, but that might be a lot of internal work from our BI teams.

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 [RESEARCH SERVICES] FP&A Director 📍Washington, US The Urban Institute is a non-profit research organisation focused on conducting social and economic policy research to address urban and societal challenges.  [IT SERVICES & CONSULTING] FP&A Controller 📍Bussy-Saint-Georges, FR TD SYNNEX is a global technology distribution company that provides a wide range of IT products and solutions to businesses.  [RETAIL] FP&A Director 📍Vienna, AT C&A is an international fashion retail chain headquartered in Belgium, offering affordable clothing and accessories.  [RETAIL] Contrôleur de Gestion 📍Lezennes, FR Leroy Merlin is a French multinational home improvement and gardening retailer, offering a wide range of products including building materials, too

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 📍London, UK Camino Search specialises in placing exceptional financial, strategic and commercial talent into high-growth tech and tech-enabled businesses.   [FINANCIAL SERVICES] FP&A Director 📍Remote, US Prosper Marketplace is a fintech pioneer with a mission to advance financial wellbeing by providing affordable financial solutions to consumers across the credit spectrum.  [FINANCE] Interim Head of FP&A 📍Berlin, DE Finatal operates within the recruitment industry, specifically focusing on finance and accounting roles within the private equity and venture capital sectors.  [FINANCIAL SERVICES] VP Strategic Finance 📍Paris, FR Qonto is a French fintech company that provides online business banking services,

Hi, I want to use the AND function together with the IF function in one formula in a property of a transaction list. Is this possible in Pigment? I can’t seem to get the AND part to be recognised when using it as part of the logical test of an IF statement, the way you can in Excel. In Excel for example I can write an IF statement using AND:=IF(X2>7,"check",IF(AND(E2="Direct",M2="Retail O&O",X2>0),"check","OK")) But in Pigment when I type AND as part of my IF statement, the function doesn’t seem to be recognised and my formula doesn’t work. The text for ‘AND’ doesn’t show up in green the way it does for the IF function (or other functions.) I don’t have any issues using the IF function otherwise, or nesting multiple IFs in a formula, it’s just that I can't seem to use IF with AND. Please let me know if it’s possible, or if perhaps I need to write it in a different way? If not possible I suppose I can create a separate property to do the AND check. Thanks,Cat

HiI want to sum the values from my current starting point to the last value available in a metric. As you can see first value is 0.22 and last is -30,993,214 and sum of all those in middle will be 30,669,213 something.that metric called inp_when to sell asset differs for each sage entity asset. How can i go about doing this calc in simple way? I tried moving sum etc but doesnt work. 

Hello,I have created the budget based on historical data (budget version based on actuals version up to a switchover date), but at each closing period and when we import the new data, the historicals can vary so it makes my whole budget move… The uploaded data for the actuals is imported into several transaction and dimension lists.It is not optimal as the budget should be closed as of now and not moving. Has anyone encountered the same issue? The idea would be to be able to use the budget version in comparison tables so it needs to be fixed in the app.Hope this makes sense!Thanks,Elodie

Hey,I am trying to reference the headcount for December and apply it to all months in the relevant financial year as part of a calculation. i.e if head count in Dec 24 in 100 and Dec 25 is 150, the formula would show 100 for all months in 2024 and 150 in all months of 2025.Has anyone done anything like this before and found a solution? Thanks! 

Hello Group! 🌟 Opportunity Alert at Uberall 🌟 We're on the lookout for an FP&A Analyst to join our vibrant team in the exciting SaaS startup world, on a 10-month maternity cover contract with great potential for subsequent permanence and growth within our FP&A team. This is a fully remote position 💻  in Spain-EU! 👉 Interested? To learn more and apply, visit our site: https://jobs.eu.lever.co/uberall/461f80c2-9613-44f4-ba19-a6ec238fe23eDon't miss this chance to grow professionally and be part of our thrilling journey at Uberall. If this role isn't for you but you know someone perfect for it, please share this opportunity! 🚀

Hi! Can someone please help with setting up the formula for below? Thanks in advance!----Dates:Given Data (yellow highlighted) Question: I am seeing for formula to get the result below yellow highlighted row, “Result”.  The calculation starts from 3rd months from the start date, 10/31/2022. So it needs to calculate “January value 18,792 minus start date value 18,792. The result for 2023 Jan is zero. Then, calculation is same concept but moves forward. It’s always deducting the start date value, 18,792.  For July 2023, calculation is July 2023 19,355 minus the start date value 18,792, resulting 564.The calculation should stop in Bridge end date, 12/31/2023.   Thank you!

Hello, I have gone through all of the available training and videos for Pigment modules and setting up Demos. I would like to know if there are any additional Demo resources and data I can use to test my skills.

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 [FINANCIAL SERVICES] Head of Strategic Finance 📍LA/NY, US Circle helps businesses and developers harness the power of stablecoins for payments and internet commerce worldwide.  [FINANCIAL SERVICES] FP&A Director 📍London, UK Tide is a financial technology company that provides business banking services tailored for small and medium-sized enterprises (SMEs). Head of FP&A 📍Uusimaa, FI Finatal is a UK-based recruitment consultancy firm specialising in finance and accounting roles within the private equity and venture capital sectors.  [MANUFACTURING] Head of FP&A 📍Augsburg, DE KUKA is one of the world’s leading suppliers of intelligent automation solutions, offering customers everything they need from a single source.  Hiring? Submit a job!Other Ro

Which formula can I use for Net Income at my balance sheet in the begging of the year where I need to transfer all Net income to Retained earnings / losses and start accumulate again? See below an example. I read this article below but I couldn’t understand: 

Hi TeamI have a calc which uses Year dimension and the year starts from 1 to 20. There is an assumption metric which defines what year the crops will be harvested. So lets say currently the assumption is year 6 in which the crops will be harvested, then from that year onward second rotation will start and then follow similar process until Year 6 where it again will be harvested and planted again.So as an example in excel, you can see from FY19 the year starts as 0 as that is where initial plantation happen. Then it counts from Year 1 to 6 and then at Year 6 which is equal to our assumption metric (Year 6) as well, it stops and then a new cycle starts from 0 to 6 all over again. How can we built something like this easy way? I have tried thinking of using MOD in which lets say in our Year dimension, we have count column as well that goes from 1 to 20 . So what i am doing is saying if Year.Count/Assumption metric =0, then mark it as harvest year.  Now how can i get it to count and reset

Hi!I have a sales volumes metric with dimensions Category, Channel, Product and Month.Data was imported from a transaction list.I want to adjust this with some volumes that are manually input by user per channel, but I want to spread this values on every product using the same weighted distribution per category and month as the initial data. For example, if on month Jun, on a product, the volume was 15% of the total, I want to add on that product for Jun 15% of the manually added volume.How do I achieve that?Thanks in advance!

Hi,Is there a way to remove blank cells in the grid of a transactions list. I am applying a filter to the transactions list which gives me blank rows which I want to get rid of. Thanks

Hi,Is it possible to filter a dimensions list based of another dimensions list e.g. if I want to just filter for Revenue, can I filter based on the classification field which comes from another dimensions list.

Does there exist a way to take the commentary (a metric of type text) from across two different tables? For instance, commentary about an Opex Expense related expense, for example Travel Expense (table 1) and Employee Expense (table 2).  Each table has a different set of metrics and each allows for text entry to supplement the expense to provide additional detail.  Downstream the request is to compile all expenses in a FPA view of all expenses entered across the company and then additionally to include the expense detail (text) with the relevant expense lines.  Bringing the data from the two different tables is no issue as we can use the “+” operand to include data from both tables.  This presents an issue when attempting the same with Text as the metric type of text does not accept Text as an arithmetic operand.  I attempted to utilize & but that did not align properly to the relevant line items being planned.  Curious if anyone else has come across this...