Explore the Community

I have created a monthly P&L with Budget vs Actual columns. When I want to see YTD numbers, the total column at the end adds up both Budget & Actual numbers. Is there a way to see the totals for Budget and Actual separately?  

Hello friends, On Friday April 14th, we will be making some changes to the Autosave functionality and the default Autosave behavior when inputting data in Sheet View. What is the “Autosave off” feature that will be released on April 14th? Now Members with Configure Blocks permission will have a block-level setting controlling Autosave.  This setting is now available on all block types and determines if inputs within the block are automatically saved or not. While already existing, the Autosave functionality was changed to expand its functionality to Boards for all types of display modes and not only Sheet view, making it more accessible to Members inputting data on Boards. This change also enables the autosave setting to be consistent across users and views. How does this impact Sheet view? On April 14th, Sheet view’s default behavior will change from Autosave being off to Autosave being turned on. This means Members will no longer have to save inputs before they sync with the rest of

Asking just for knowledge,What maximum size of excel can we import manually in transaction List?If our excel size is more than required size than what solution is available in Pigment.

Hello,I have 2 metrics :Actual with Dimensions : Client, Region, Sales Area, Period Type (Actual) Budget with Dimensions : Region, Sales Area, Period Type (Budget)I want to add these 2 metrics and keep the Client dimension. If I select Budget as Period Type, I just want BLANK for the Client dimension, if I select Actual as Period Type, I want the figures for the client dimension.Is it possible to do it ?Thank you

Hi Everyone, I’m trying to find a more efficient solution to modeling our yields. We have several dimensions by which we measure yields (region, segment, ramp status, etc...) and currently have separate blocks for each measure which can lead to confusion. I would like to consolidate yield calculations into a few blocks and pivot from there on the necessary dimensions. Any ideas on how to best set up yields?

Hello,Is there a way to receive an email if an automatic import with an API fail ?Thanks,Alexandre

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 FridayExecutive positions1️⃣ [ADVERTISING] Associate Director, Financial Planning and Analysis @ Publicis Group, the third largest communications group in the world.Partner with Department leads to understand business needs and translate into a departmental expense forecasts. Take a business interest in managing forecasting accuracy of amounts, monthly phasing and categorization. Proactively question processes and procedures and implement change to gain efficiencies and streamline workflows.📍 Chicago, US 2️⃣ [FOOD&BEVERAGE] Director Group FP&A @ Carlsberg Group, one of the leading brewery groups in the world.Augment data with business insights to identify opportunities that can help drive the top-line growth and/or cost reduction. Hold functions and regions accountable for performance, advising the senior finance and business l

Setting up SFTP question → submitted a request for it

Hi Community Members,I would like to know for knowwledge that there is any limitation to create no list properties and no of rows in Dimension and transaction List of pigment.Means:How many no of properties and rows can we create in Dimension and Transaction List?

Hi Pigment Team,Could you please share examples of NPV and XNPV Function in details?

I’m looking to delete scenarios from my application; however, I’d like to retain the data from a child scenario instead of the parent scenario. Is this possible to do?  

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 Friday Executive positions1️⃣ [SOFTWARE] VP Financial Planning & Analysis @ Outbrain, a leading recommendation platform for the open web.Set a vision for executive level metrics and systems support that ensures we can track, measure and optimize our business, at scale, across our product, sales and finance teams. You will manage a high performing global team of FP&A analysts/managers. Oversee and own revenue and departmental operating expense forecasting and business reporting for executive departmental leaders, the board and investors.📍 Remote, US 2️⃣ [SOFTWARE] VP, Financial Planning & Analysis @ Houzz, a platform for home remodeling and design, providing people with everything they need to improve or design their homes from start to finish.You will oversee a talented team of finance professionals and will be responsible

Hello,I have 2 Transaction Lists :List 1 : with Doc # (string), Parent Item (Dimension), Product Lvl 2 (Dimension) List 2 : with Doc # (string)None of the Doc # is unique on both Lists.In List 2 I want to retrieve Parent Item following the rule : IF List1.Doc # = List2.Doc # AND Product Lvl 2 = “VPS” Then Parent Item (Dimension)I tried this but doesn’t work and I don’t understand why.  In my screenshot, P&L.Transaction = Doc # from List 2 and Transaction List.Document Numer = Doc # from List 1Thanks for your help ! Alexandre

Hi!I’d like to create a metric to keep track of the number of outstanding customer invoices over time.I have an import from the ERP system with the status of every issued invoice, and the following columns:Customer Number Invoice Date Payment DateThe metric should be of dimension Day, and should return the # of outstanding invoices at any given time.Excel equivalent:1. Generated a sequence of days ( → Day metric in Pigment)2. Use sumproduct formula for the aggregation=SUMPRODUCT((Invoice_Date>=Day)*((Payment_Date>Day))+(Payment_Date=0))What would be the equivalent formula in Pigment for this?

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 Thursday Executive positions1️⃣ [SOFTWARE] SVP, Finance FP&A @ Forsta, supports the insights technology needs of more than 3,000 businesses, including 1,000 market research agencies.The position is responsible for providing insight and operational support to achieve near term budgeted sales, revenue and earnings objectives and to position the Company for longer term sustained revenue and earnings growth. The position manages a global team of financial planning and analysis professionals.📍 Chicago, US 2️⃣ [SOFTWARE] Director FP&A @ Alarm.com, provides cloud-based services for remote control, home automation, and monitoring services.Build and manage both the finance and the accounting functions and play a key role in optimizing financial performance at 'Alarm.com Advance', a consumer financing FinTech subsidiary c

Hello !I have created a table to display our monthly key figures with actuals vs budget. I have added the following columns with the calculated item function: YTD values (with the cumulate option in the calculated item), and variation in € + variation in % for the monthly and YTD values.When my initial data is in number it’s ok, but I don’t know if it’s possible to use the calculated item option for calculating YTD values in % and calculating their variation (for example gross margin % and EBITDA %). Could you please help me to find the best way to calculate these values in my table?Hope my request is clear enough!Thanks,Elodie 

Hello,I need to create a IF condition that shows : IF date 1 > date 2, then blablabla. Date 1 : Current date, it’s a metricDate 2 : Go Live date, it’s a date from a transaction I did this formula :But I have this error. Here is my Month Dimension :  Thanks for your help :)

Hi everyone, I'm facing an issue for creating metrics that are on a "per basis". They're divisions between 2 sums.Those 2 sums (let's say A and B) are defined across the same 6 dimensions, and individually work fine and aggregate as sums on any visualization with them even if I pick let's say 3/6 dimensions in which they existHowever when I create a metric dividing those metrics A and B, we face issues when displaying on a table 3/6 dimensions, because there's no option to define the order of operations, and what happens is:- The table calculates A / B on each combination of 6 dimensions- Aggregate as sum of (A / B) on the table at displayWhat needs to happen is:- Calculate sum of A- Calculate sum of B- Divide sum of A by sum of BAnd we couldn't find a formula to do this, or make explicitly how we want to aggregate.Those are semi-additive measures, and maybe this example on DAX helps:https://www.sqlbi.com/articles/semi-additive-measures-in-dax/Thanks!!

Dear Pigment Community,I hope your week is starting off well! I am Regina, on the Product Marketing and Analyst Relations team and I wanted to share with you something we’re working on. We are currently participating in Dresner Advisory Services Wisdom of the Crowds EPM market study, to help them create a holistic view of the EPM market. We would be hugely appreciative if you participated in their end-user survey to share your Pigment experience.If you’re up for helping us, please take five minutes to share your experience with Pigment, by Friday, March 31, 2023. You only need to complete the sections relevant to you, and you can skip areas which aren’t applicable. As a thank you for your time, Dresner will send you a complimentary copy of its research findings once the research is published this summer.Take end-user survey hereThank you!!Regina

Hi Team,I was trying to view “Build collaborative sales planning and forecasting models” webinar on community but it seems like i donot have access to view it as i am unable to see any link which can run the webinar for me. Kindly help me with the issue 

Hello,It there a way to retrieve the User name from “User” ?Thanks 

Every quarter we award our most active users of Pigment with the Top Modeler badge.Top Modeler Q4 2022 BadgeWe’re delighted to announce the recipients for Q4 (closing out 2022!) as:@Eda, @Yannick, @Rares,  @aufdenkamp, @rschimm, @Anne-Laure, @Cécile,  @venitiav,  @LEO E,  @Antoine,  @ClementineEv,  @Anthony,  @Omer Nahum,  @JSU,  @ostaiger,  @Steven Congar, @JuliaSp  🏆🏆🏆Thank you for your commitment and exploration of Pigment! We’re excited to hear more about how you’re using Pigment at your organisation. 👏

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 positions1️⃣ [SOFTWARE] Director of Group FP&A @ RWS, the world's leading provider of technology-enabled language, content management, and intellectual property services.You will work across group finance and the wider business to deliver world class commercial finance reporting, planning and analysis which supports the Senior Leadership team of RWS in making better informed commercial decisions. You will lead the Global planning, budgeting and forecasting processes. Establish the FP&A finance team operating model to deliver efficiency gains and create capacity for enhanced strategic performance reporting to support decision making.📍 Maidenhead, UK 2️⃣ [FINTECH] Director of FP&A @ Chargebee, subscription billing and revenue management platform.To lead development of the annual expense forecasts for company’

Hello,I am trying to create a metric that shows the month tenure by employee in a cohort, with the cohorts in rows and the month cohort dimension in columns (i.e. M+1, M+2, M+3, etc.). For example, an employee who arrived in May 22 is part of the May 22 cohort and if he leaves in September 22 it would put a 1 in the column "M+4" for the row "May 22".I have an “Employee” dimension with a property for the cohort (for example May 22) and a property for the number of months of employment (for example M+4).Could you please help me to build in the best way the described metric?I hope my request is clear enough!Thanks! 😊