Explore the Community

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 [SOFTWARE] Contrôleur de gestion  📍Boulogne-Billancourt, FR Odigo provides Contact Center as a Service solutions that facilitate communication between large organizations and individuals.  [FINANCIAL SERVICES] FP&A Director 📍London, UK Equiniti is a financial services company specialising in business process services, offering technology-driven solutions for administration, payments, and related services primarily in the financial and public sectors.  [MANUFACTURING] FP&A Director 📍Anderlecht, BE UCB is a pharmaceutical company with a focus on developing and manufacturing innovative medicines.  Hiring? Submit a job!Other Positions [SOFTWARE] Financial Planning & Strategy Manager 📍San Francisco, US Checkr provides background check services to

What are the best pratices for intercompany process (Eliminate inter-company transactions )

Hi Pigment Community,I’m currently working on building a conversion rate forecast in pigment and wanted to hear your thoughts on my calendar setup. Context: In our forecast model we are interested only in the current year and previous year. Information older than that is not being included in our forecast, visually and mathematically. Thus, I wanted to have an automated rolling calendar on an annual basis. This way if we are in Oct 2023 my model will show Jan 2022 - Oct 2023, rather than Oct 2022 - Oct 2023.I know that in pigment you can use item variables to easily update variables, such as year, for all views in a model. However, I have opted for a different solution. Instead I have tweaked the ‘Period type’ dimension to include a 3rd item called ‘Actual old’. I then filter my metrics on all data where period type does not equal ‘Actual old’. Additionally, my period type is decided by my switch date, which is automatically chosen based on the max date in my data transaction.Current p

Dear All, How to construct a formula for moving multiplication? Similar to MOVINGSUM but with * rather than + ;)The input is a % movement in given month as per below and I need to construct a compound growth rate. I.e. in 2028 it is 0.9438 (1.3*0.6*1.1*1.1) 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 weekExecutive Positions [RESEARCH SERVICES] Contrôleur de gestion  📍Paris, FR The Institut Pasteur is a leading global biomedical research institute.  [ADVERTISING SERVICES] FP&A Director 📍Chicago, US Publicis Groupe is the second largest communications group in the world.  [SOFTWARE] FP&A Senior Director 📍London, UK insightsoftware is a global provider of reporting, analytics, and performance management solutions.  Hiring? Submit a job! Other Positions [MEDIA] Global FP&A Process Owner 📍Manchester, UK ITV is a media company that operates commercial television channels, producing and broadcasting popular programs.  [FINANCIAL SERVICES] FP&A Manager 📍London, UK Tide is the leading provider of UK small business (SMEs) accounts and one of the fastes

Hi Pigment Community, I am trying to create a KPI that tracks the ratio of blank cells to filled cells for a column in a transaction list. In addition I want this KPI to be dimensioned so that it can be affected by the page filters, however I can’t seem to figure out a solution and was wondering if any of you had a solution for me. So far I have attempted 4 different solutions, however none of them have given me exactly what I am looking for. Below I have provided screenshots of the different parts that contribute to my problem. As I have tried different solutions and none of them have worked I have provided information for each formula, as I don’t understand why each one gives me a different output. My end goal is to have the proper ratio of (all blanks) / (all blank + nonblank) which can be filtered by dimensions using the page option. Specifically: year, deal status, and HB - Deal Owner. Extra info:All deals - total row count = 5,504All deals.segment = blank = 292Ratio = 292 / 5504

Hi Pigment Community!I am trying to create a year over year moving average but can’t seem to figure it out. I was wondering if any of you had some suggestions for me. The issue I am trying to solve is that I have a conversion rate calculated in a metric. Using that metric I would like to calculate the difference in moving average between the current year and previous year. Formulaically it would be: (Moving Average Current Year) - (Moving Average Previous Year) * 100. In addition I want to incorporate my switchover date so that my metric will continuously update itself as new information comes in.  Currently I have this formula in mind, but it doesn’t work. Perhaps there’s a better way, or my formula could be tweaked. MOVINGAVERAGE('[ % ] Opportunity to Customer', 3) - MOVINGAVERAGE('[ % ] Opportunity to Customer', 3, 0, '[ % ] Opportunity to Customer'.DATE(YEAR(EDATE('Switchover date', -12)), MONTH(EDATE('Switchover date', -12)), 1)Opportunity to Customer - MetricWhat I envision is: (

Hi, I am very new in Pigment and try to get used to the multidimensional thinking.I have a transaction list containing employee and department and a calculated salary metric with monthly salary per employee. I want to group the salaries per department. Please assist

 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  [SOFTWARE] FP&A Director 📍Remote, US EagleView is a leading provider of aerial imagery, property insights and software.   [MANUFACTURING] FP&A Director 📍Paris, FR Sodiaal is a dairy cooperative specialising in the production and marketing of a diverse range of dairy products.  [MANUFACTURING] Head of Finance 📍Cologne, DE Siemens is a technology company focused on industry, infrastructure, transport, and healthcare.   Hiring? Submit a job! Other Positions [MARKET RESEARCH] FP&A Manager 📍London, UK YouGov is an international online research data and analytics technology group.   [SOFTWARE] Senior FP&A Specialist 📍Remote, Canada Clio is the leader in cloud-based legal technology offering practice management, payments,

Hi Community,is it possible to have a monthly ARR ranking metric which combines globally & regional rankings? e.g.Page Filter “None/All”, globally,Page Filter “EMEA”, ranking within “EMEA”,Page Filter “AMERICAS”, ranking within “AMERICAS”,etc.I was able to create a global & a regional view but it would be great to have this combined for our Dashboard, so that we can toggle through the regions. Thanks & BR,Daniel

Hello,I granted everyone admin rights to see and write in the application, however there is one specific metric, which no one else besides me can see. Did you maybe have a similar case or know what the issue might be?Thanks!

It seems that it is not possible to change the color of an “open” text widget. When changing color it goes back to “filled”.Is it a bug or should I create an Idea ?Thanks!

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  [HOSPITALS & HEALTH CARE] Head of FP&A,📍Sevenoaks, UK The Active Care Group is the UK’s leading national provider of complex care, harnessing innovation to raise standards and deliver better outcomes.  [TELECOMMUNICATIONS] FP&A Controller,📍Rotterdam, NL KPN is a telecommunications company that provides a variety of services, including fixed and mobile telephony, internet, and television.  [SOFTWARE] FP&A Director,📍Boulogne-Billancourt, FR Odigo provides Contact Center as a Service (CCaaS) solutions that facilitate communication between large organizations and individuals thanks to a global omnichannel management solution.  [FINANCIAL SERVICES] FP&A Director,📍Paris, FR Qonto is the leading European business finance solution. It sim

We’ve recently updated our block headers for a more simplified look. This article is designed to outline all the new behaviors.  Introducing the Formula icon for hiding the formula bar!  There is now an formula icon that can be used to hide and show the formula bar. Members can click the new formula icon to expand and collapse the formula bar. Also when using the drilldown options, Members can click on “Show/Hide formula breakdown” to expand and collapse the formula bar.We optimised the experience for each type of user. If the Member is considered a “modeller” (either have the ‘Can Configure Block’ or the ‘Can Open Block Explorer’) then the formula and the formula breakdown will be displayed by default. All remaining Members will be considered as “contributors” and the formula and formula breakdown won’t be displayed by default. All users have the ability to show/hide formulas. Block Header Changes: New options in block menu: A new option menu now appears in the top right. This menu in

When I want to get the most recent date of the sale of a particular product, I can use BY FIRSTNONBLANK aggregator to get the value from the Transaction list of product sales data into the metric.But, how do I select the 2nd most recent date?For instance, I have the following sales table:Product         Qty.        DateProduct A.      30.        5/12/2023Product A.      40         3/26/2023Product A.      15.        1/11/2023I would like the metric, which I’m creating, select the 2nd row’s date, i.e.:Product A.   3/26/2023

Hello, I am using this formula to calculate the IRR amount, but it does not return anything. Could anyone help please ? Thanks in advance.IF(CoC<1,XIRR(Amount[ADD: Company][filter: LEFT('Transaction ID'.Name,8) = Company.Company][BY SUM:'Transaction ID'],-0.2,FALSE,Day),XIRR(Amount[ADD: Company][filter: LEFT('Transaction ID'.Name,8) = Company.Company][BY SUM:'Transaction ID'],0.1,FALSE,Day))  

Hi folks,The following query is about generating a Metric with data type dimension “Employee”The metric is counting how many items of a Text metric 1 are in another Text Metric 2.I use the following formula:If ( Text Metric 1 = Text Metric 2, “Employee”) [REMOVE Lastnonblank: Month, 'Employee']My problem is that I have no results when I should have. Thanks in advance!! New Metric - Type Dimension (Employee) Text Metric 1 Text Metric 2 Cost Center Cost Center   Entity Entity   TBH Request TBH Request   Version Version Version     Month     Employee

Hi Team I have a use case where i have certain questions as a dimension and there are in total 160 of them. We ask each property manager these question but for lets say Property A , we ask 50 questions and for property B we ask all 160 of them.  How do i apply access right so only relevant questions get assigned to each of the properties? It doesnt need user access , just need to define it by property itself and questions. Secondly, then i need to create a metric to track progress rate as to how many of these questions are still blank and for that as well, i need to divide it by only the applicable questions. So for example property A have 50 questions to answer and he have only done 5 so far, then my progress rate should be 5/50 i.e 10% not 5/160 which is taking the whole 160 questions in the original list of questions. ThanksMusab

Hi there! On the topic of the FORECAST_LINEAR formula: Is there a way to select certain values for the ranking dimension? For example, if:Forecasted Sales =FORECAST_LINEAR('Sales','Month’) Is there way to choose certain months you want to use for the regression? In my case I am trying to using TTM (which I currently have as a Boolean property of Month)

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  [MANUFACTURING] Head of FP&A,📍Munich, DE Lilium GmbH is a German aerospace company which is the developer of the Lilium Jet, an electrically powered personal air vehicle capable of VTOL flight.  [IT & SERVICES] FP&A Director,📍Tysons, US Alarm.com is the leading platform for the intelligently connected property centered on security and remote monitoring.  [MANUFACTURING] FP&A Director,📍Rueil-Malmaison, FR The Mayoly Spindler Laboratory is an independent and international French laboratory that has been developing for more than a century.  Hiring? Submit a job!Other Positions  [GAMING] Junior FP&A Analyst,📍Paris, FR Ubisoft is a provider of gaming services that publishes and distributes video games in both physical and online formats

How can you adapt the index match function in a transaction list to handle a many-to-many relationship, where a combination of 'Region' and 'Department' might correspond to multiple 'Project Codes' and vice versa?For example, both Region '1' and Department 'A' could be linked to multiple Project Codes, and a single Project Code could be applicable to various combinations of Regions and Departments. What techniques or formulas can we use to index match on these two properties simultaneously while managing such a many-to-many relationship?

Hello,I created the below metric but the result is not what i expect.I would like to have only the “new deals. TTR first date” for the “Budget 2024” version.Currently my metric is displaying the “new deals” dimension list of all my version (Reforecast july 2023 and Budget 2024). Version is a property of New deals.You will find below the new deals dimension list.thanks for your help 

How do you guys lock headcount for a 3+9 or a 6+6 for example? Our headcount comes as an import from our HRIS load. But since we can’t apply scenarios to transaction lists, our locked 3+9 contains items from the current day.

Hello Pigment community, I am having trouble creating a metrics to compute my ageing balance. The aim is to create a metric that would calculate the delay in days between the due date of each invoice and the current day (today). I tried to find workaround on this in the community but i can’t make them work in my case. I saw as well that a replica for Pigment of the excel function TODAY() was under development but i did not see if that was live or not. Can you help me ?  Thanks a lot 

Hi, good morning everyone! I have an error and I can’t solve it, could you help me out with a solution please? I have the formula: 'All Deals'.'Deal ID'[BY COUNT: 'All Deals'.'Country/Region'.Country.'Group', 'All Deals'.Segment.'Segment Simplified', 'All Deals'.Pipeline.'Pipeline Simplified', 'All Deals'.'Create Month']Every time I try to run the formula I get the error: Error: Unknown List Property: Country mapping.Country For more context: All Deals is a transaction list that has various dimensions and lists within it. I am trying to build a formula that will have the country group on the y-axis and month on the y-axis. I have used the dimension “Country mapping” to convert all the different languages of countries to english. The dimension “Country mapping” has a dimension called “Countries english names” that comes from the “Country” Dimension, specifically the ‘english’ column. Using my formula I expect to call the “country mapping” dimension and then through its associated proper