Explore the Community

Hi everyone!I would like to know which encoding is recommanded when importing a document containing € signs. I usually pick the “Western European (ISO)” encoding but the € signs are not compatible:Could you please help me understand if this comes from the encoding or if I should adjust another parameter when importing data?Thanks! 🤗Elodie

Introducing Pigment Sheet View! After much anticipation, Sheet View is finally live in Pigment! 🥳Sheet View is a new view option that allows you to make use of Pigment’s flexibility and real-time updates in a familiar spreadsheet layout, making it easier to use Pigment as your single source of truth and collaborate productively within the platform. “Sheet View gives you that last-mile flexibility without leaving Pigment.”– Jose Ramon Iglesias, VP of FP&A at Uberall Click here to read the technical documentation and discover the full functionality of Sheet View!  Who is Sheet View for? Sheet View is for all Pigment users, but depending on what you’re trying to achieve, it may be useful to different people in different ways.For modelers, Sheet View is most useful as a sandbox-style environment to help make modeling decisions by running calculations on existing data. This can provide context for your logic and thinking for later reference.For those using Pigment primarily for insight

A quick reminder of what you get with our weekly jobs newsletter:  Around 10 fresh job offers  From top companies from all around the world  Every Thursday  You can subscribe to the Jobs Newsletter by clicking here Executive positions [FINTECH] Director, FP&A @ Figure, transforms the trillion-dollar financial services industry using blockchain technology.You will report to the Chief Financial Officer and work closely with Finance, Accounting and Business leaders to drive our financial planning, forecasting, reporting, and ad hoc financial analysis. In addition, the role will work on strategic transactions which include product pitches, SPAC pitches and acquisitions. Remote, US  [REAL ESTATE] Head of FP&A @ Mynd, a tech-enabled real estate company serving the $85B+ property management and real estate investment market.You will play a critical role in the development and implementation of financial, strategic and growth objectives aimed to provide long term profitable growth

I have a boolean metric with three dimensions: Position, Version and Month. Position Version Q1 Q2 Q3 Q4 001 Forecast ☑️ ☑️ ☑️ ☑️ 001 Plan ☑️ ☑️ ☑️   002 Forecast ☑️ ☑️ ☑️ ☑️ Positions can be a part of different teams over time. I have another metric, *Position Mapping* which is of type Team with the same dimensions as the boolean. Position Version Q1 Q2 Q3 Q4 001 Forecast Team A Team A Team A Team A 001 Plan Team A Team B Team B   002 Forecast Team X Team X Team Y Team Y  Now I want to add the Team dimension into the first metric. I have tried doing it like this:‘My boolean’ [by: → ‘Position Mapping’]Team Position Version Q1 Q2 Q3 Q4 Team A 001 Forecast ☑️ ☑️ ☑️ ☑️ Team A 001 Plan ☑️       Team B 001 Plan   ☑️ ☑️   Team X 002 Forecast ☑️ ☑️     Team Y 002 Forecast     ☑️ ☑️  This achieves the goal except for one thing. Wh

Hello,I have a metric (dimensions Month and Employee) where I have the Country of an Employee by Month (for example : from Jan 22 To Jun 22 → France, From Jul 22 to Dec 22 → UK).I have a Transaction with financial accounts with columns of Month and Employee ID.I need to get the Country of the Employee in the Transaction, according to the Month. How can I do that ? Thanks,Alexandre

Hello Pigment Community, I am trying to calculate the quarterly bonus of my employees and shift it by one month to simulate the payout on the first month after the quarter end.I will detail below the steps of my calculation and where I am stuck:My bonus expenses are by month. I was able to sum the quarterly amount with a [BY SUM: Month.Quarter] modifier. I want to add again the “Month” dimension and put this quarterly amount on the last month of the quarter only (or first month of the quarter, it doesn’t matter). This is where I am stuck. If I use a [BY CONSTANT: Month.Quarter] - the amount is written on all months of the quarter, and then I am unable to filter only on the first or last month of the quarter. The last step will be to SHIFT this amount by 1 month to simulate the payout on the first month after the quarter ends.  I would appreciate your help if you already worked on this topic! Thanks in advance,Steven

Wondering if there is a way to handle special characters that are present when dimensionalizing a text field where they are initially present.  In this example, the tilde over the “e” in cafe shows properly on the “Channel Name” of Type Text, but does not within the “Parent” field of type Dimension.  

A quick reminder of what you get with our weekly jobs newsletter: 👉🏿 Around 10 fresh job offers 👉🏻 From top companies from all around the world 👉 Every Thursday  You can subscribe to the Jobs Newsletter by clicking here  Executive positions  FEATURED🌟 [FINTECH] CFO @ Kaiko, bridge traditional and blockchain ecosystems by providing reliable and actionable financial data and services.Responsibility for investor relations, financial due diligence as well as the execution of mergers and acquisitions, company structuring as well as oversight of the finance & accounting and financial planning & analysis teams, company audits and financial operations of the organization plus tax and asset management strategy of the company. Paris, FR or London, UK→ Send a note to Ambre (CEO) for a direct intro  [SOFTWARE] Director, Corporate FP&A and Reporting @ SoundCloud, a next-generation music entertainment company powered by an ecosystem of artists, fans, and thriving communities.Re

Hi Pigment team,I need your help on creating a metric that reflects the values of prior period for a given metric, in a flexible way that allows me to change to quarters, months and doesn’t lose accuracy when aggregating.Thanks for your help :)

Hello Pigment Community, We are importing our General Ledger in a Transaction Table. In this Transaction Table, we have 2 key information that we are trying to rework:Document Number CC ID (= it’s the department ID) Our issue is that we have multiple lines for the same document number with multiple CC ID. Our objective is to get a unique list of document numbers with a unique CC ID attached to it. We know in advance that a specific list of CC IDs are not relevant and that we want to exclude them. If you look at the screenshot below, we have multiple lines for the Document Number “JOUFR12797”. We want to attach to this document number which CC ID it is flowing to. Our standard CC ID is a set of 3 digits, followed by the name of the department. Here, it is “340 - Customer Experience”. The others CC IDs that you see on the screenshot (“4 - P&L Allocation..” and “5 - P&L allocation”) are not relevant and we don’t want them in our unique list. What we want is basically a unique list

Hi Team,I just want to know is their any way by which pigment can automatically generate some number/code to a line item so that unicity remains in the list and once the code is allotted to a line item it can’t be changed even after the line item is deleted.   Thank you in advance 

Hi Community!Love our trace dependent feature for tracking interlinked metrics/data sources but I’m wondering if there is any way I can see from a dimension which metrics/applications it is being used in. Wanting to do some cleanup of our dimensions and prior to deleting I want to find a way to ensure I won’t break anything after deleting.Thanks!

Hello community! I’v created several boards with sames tables but for different stakeholders (Top management, Finance and People). However people should not see details of people department, Top management should not see top management department for confidentiality matters. How can i create access rights on a dimension ? In fact, all tables have the dimension “Direction” and I want to create access accoding to this dimension (ie people could not have access to people). Thanks a lot!

For all the new joiners, a quick reminder of what you get with this newsletter: Around 10 fresh job offers From top companies from all around the world Every ThursdayYou can subscribe to the Jobs Newsletter by clicking here 💌 Executive positions [SOFTWARE] Director, Financial Planning & Analysis @ Aura, a suite of intelligent digital safety products that help millions of customers protect themselves against digital threats.You will help influence the strategic direction of the business through insightful analysis and business partnering. We are looking for a highly motivated individual with strong analytical and communications skills as well as experience telling the company’s “story” to executives. Boston, US  [SOFTWARE] Head of FP&A @ Edenred, a leading digital platform for services and payments and the everyday companion for people at work.Reporting into our CFO, this position with be a leading contributor and you will be core to our short, medium, and long term plans and s

Hi Pigment team:I’m trying to format the formulas so I can make them easier to read.For instance, I have a formula that is an addition of 4 items and goes on for 5 lines (difficult to read), I’m looking to structure the formula in 4 lines (easier to digest):= Item 1 +Item 2 +Item 3 +Item 4 Is this something we can do? Thanks in advance :D

I think this is a simple problem, but it probably isn’t. I have a metric (Metric - Is locked) of type: Dimension (Locked) with only Yes or No as options. Dimension: Version Metric: Yes/No Actuals Yes Plan Yes Forecast No  Can I easily flip this around to show the inverse of the metric (here using firstnonblank)?Dimension: Locked Metric: Version Yes Actuals No Forecast  

Hello Pigment Community, I need your help on calculating merit increase for existing employees. To give you more context, our merit increase calculation is made of:1. The annual package of an employee → this is the basis for our calculation. 2. The merit increase % : it will be applied to the annual package and is cumulative through the years. 3. The merit increase eligibility: we calculate it based on the start date of the employee. 4. The timing / effective date of the merit increase: it is the month the merit increase will be effective.We are currently stuck on the last part, which is the timing of the merit increase.I will explain quickly each component below and will explain more in details why we are stuck on the effective date and what we try to achieve.  1 : The annual package of an employee.Let’s say we have an employee making 40,000 EUR a year. We have a metric in which we have 40,000 EUR on every month for this employee.  2 : The merit increase %.It is defined by year and it

Hi Pigment community, My case description:I have 3 Transaction List [TL], which have accounting transactions, I added to those list identical dimension.Then I have created a “Staging Metric” that’s adding up for 3 [TL] the column “USD Net value” (number property), on the following dimensions [by: Company, ‘Company and Account’, Month]Note: ‘Company and Account’ dimension is the lowest level and from where stem the Reporting dimensions (Level 1, Level 2, Level 3).The metric aggregates well, and adds up the transaction values at each reporting level and at each time level (month, year, quarter).Then I want to create a metric that does the cumulative for “USD Net value”, so I can get the values for the “Balance Sheet” cumulating on a monthly basis. I use the following syntax:Cumulate('Staging Metric'[Filter:'Company and Account’.Report = Report."Balance Sheet"],Month) Cumulate('Staging Metric',Month)The formula works well when showing Month Dimension in the columns The problem: When showi

Hi Team, It would be a great help if you suggest some best practice to map dimensions in a dataset so that it consumes less space and time moreover data will look more clean and easy to read in pigment.  Thank You!!

Hello community :)  I have a dimension with all my employee (including externals),their start/end dates and others. Looks like this:  To create my forecast on my externals: i want to have a table aside with manual inputs for costs that i can update for each month. I do not want to compute costs by multiplying FTE according to start/end date. At resulats, i would love a metrics with my externals (job_id), costs (than i can enter manually) and months. Then i could add this metrics to my permanent employee cost metrics since i would have the same dimensions (job_id, employee, month.how can i do it ? Thanks a lot :) 

Hello,I need to make multiple different imports from Pigment to Google Sheets within a preset presentaion frame (namely, fixed row titles and fixed column titles). But instead of filling the existing available empty cells of the sheet under those row and colum titles, the import seems to be inserting new rows and new columns (as many as the total surface of the import) between existing rows and columns. Can you please help me solve this ?ThanksErwan 

Hi Pigment community, I have a Metric ‘FX rates’ that contains the Conversion rates cut by three dimensions: ‘Currency’, ‘FX Type’ and ‘Month’.Also I have a Transaction List that contain the above dimensions (as dimension property). I’m looking to populate a column in the Transaction List that delivers the ‘FX rates’ value correspondent to the row value combination for the three dimension. What would be the best formula structure to approach this task? Thanks in advance :D

Executive positions1️⃣ [FINTECH] Head of Financial Planning Analysis @ Moneyfarm, an online investment advisor and one of the largest digital wealth management companies in Europe.Lead end-to-end planning, budgeting, forecasting and reporting cycles, preparing timely and accurate information and insights to the CFO & Exco. Build strong working relationships with corporate controllership and collaborate to deliver structured, high quality accurate financial reporting on the basis of streamlined processes.📍 Milan, IT 2️⃣ [MANUFACTURING] Head of Financial Planning and Analysis @ Dyson, designs and manufactures household appliances such as air purifiers and hand dryers.you will own the delivery of accurate, timely and insightful performance analysis of Dyson’s month end financials and budgeting/forecasting, to the CFO and the wider Exec. You will be instrumental in putting together the global picture and implementing best practice, working closely with stakeholders across multiple glo

Hello,I want to use a vlookup on a non-dimension column. Is it possible ?Exemple : Dimension A : I have those 2 columns : I want to retrieve the Manager via the e-mailDimension B : I have my e-mails and my managers. Question : How can I get my managers in Dimension A ?Thank you :)

 Is there a way to delete users instead of just deactivating? I don’t see an option as primary owner.  Related: I believe currently transfer application can only be done by current owner, can the workspace owner transfer application ownership?