Skip to main content

Explore the Community

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

881 Topics
H
Newly Minted Pigmenteer
HamzaNewly Minted Pigmenteer
asked in Questions & Conversations
The difference in income between two months

I need to add a column to calculate the income [ m- (m-1)] in order to get the difference in income between two months do you know how to do it Thanks

842
H
Newly Minted Pigmenteer
E
Seasoned Pigmenteer
ElodieSeasoned Pigmenteer
asked in Questions & Conversations
Access rights in tables

Hello! I have created AR rules to give a person access to one country only. I have verified the access on all blocks through the impersonate feature and everything seems to be working. However, the person doesn’t have access to some tables (though he has access to the correct data in the metrics composing the table)… This message appears: Could you please help me to understand what is happening here? Thanks! Elodie

732
Benoit
Community Manager
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
Best practic for Actual, Budgeting and forecasting Analysis

I would like to know what is the best practice for Actual , Budgeting and forecasting. Option 1: Create a separate Version Dimension Option 2: Create Scenario for Actual, Budgeting and forecasting

2372
abhilashsawla
Benji
BenjiPigment Academic
published in Company News
Come say hi! Pigment User Group Meetups April and May: Paris, NYC, Boston & San Francisco

Pigment User Group meetups are here again! 😍 Join us to meet the Pigment team and fellow Pigment users for an afternoon of program and mingling 🎉 The goal of the Pigment User Groups is to connect, elevate, and inspire a community of customers within their local area to meet each other in person (and receive some Pigment swag ofc). When & Where? San Francisco: April 26th Paris: April 27th New York City: May 10th Boston: May 11th How do I sign up? Get in touch with your CSM for further details and to secure a spot! :) Agenda: 1:45pm - 2:00pm Arrivals 2:00pm - 5:00pm Program 5:00pm - 7:00pm Happy Hour See you there! 👋

3950
Benji
Benji
BenjiPigment Academic
published in Career Forum
FP&A Jobs #27 - Apr 14th (Deliveroo, Carlsberg, Calendly...)

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 week Executive positions 1️⃣ [SOFTWARE] Vice President, Financial Planning & Analysis @ Acumatica, a cloud ERP company that provides cloud business management software for small and mid-size businesses. Acumatica is hiring a VP of FP&A to lead their worldwide financial planning and analysis team. The position is critical to Acumatica’s continued growth and development. The responsibilities of the role include building and leading a best-in-class worldwide FP&A function, developing and maintaining high-quality business partnering activities, and collaborating with executives to provide financial expertise and guidance on strategic initiatives. 📍 Kirkland, US 2️⃣ [SOFTWARE] Senior Director, Technology & Services FP&A @ Deltek, the leading provider of small business and enterprise software for project-based businesses. The Senior Directo

760
Benji
Benji
BenjiPigment Academic
published in Career Forum
FP&A Jobs #26 - Apr 11th (WeTransfer, Deliveroo, Faire, Peloton...)

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 week 📣 Research opportunity with Pigment 📣 Our research team at Pigment is looking to learn more about individuals in Finance teams at growing companies. We are looking to speak to individuals working in Finance teams at businesses with over 2,000 employees. The team will give you a gift voucher for your time. If this sounds interesting, drop an email to ellen.humphreys@gopigment.com. Thank you! Executive positions 1️⃣ [SOFTWARE] Vice President, Financial Planning & Analysis @ Billtrust, the leading innovator in AR automation and B2B payments. As the Vice President of Financial Planning and Analysis you will be responsible for providing management with an analysis and insight of Billtrust’s financial results in coordination with the broader Finance team. You will oversee all aspects of the annual budget, quarterly forecasts, data ana

800
Benji
M
Newly Minted Pigmenteer
MuzNewly Minted Pigmenteer
asked in Questions & Conversations
How to see Budget vs Actual totals separately?

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?

36412
M
Newly Minted Pigmenteer
Chris
ChrisKeen Learner
published in Company News
Changes to Autosave in Sheet View and Blocks

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 t

4570
Chris
H
Newly Minted Pigmenteer
HamzaNewly Minted Pigmenteer
asked in Questions & Conversations
Converting date column to month dimension

5983
H
Newly Minted Pigmenteer
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
Reagarding maximum Size of Excel which can be import manually easily

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.

1863
abhilashsawla
A
Seasoned Pigmenteer
AlexandreSeasoned Pigmenteer
asked in Questions & Conversations
Dimension and addition of 2 metrics

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

2053
francois
Employee
N
Just Arrived
NicoleGilmourJust Arrived
asked in Questions & Conversations
Best way to calculate yield?

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?

2341
Nathan
Employee
A
Seasoned Pigmenteer
AlexandreSeasoned Pigmenteer
asked in Questions & Conversations
Import API

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

4556
A
Benji
BenjiPigment Academic
published in Career Forum
FP&A Jobs #25 - Mar 31st (Faire, Calendly, Carlsberg...)

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 positions 1️⃣ [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 lead

960
Benji
Jan Veerman
Budding Pigmenteer
Jan VeermanBudding Pigmenteer
asked in Questions & Conversations
Set up a new SFTP connection

Setting up SFTP question → submitted a request for it

1581
Keiran
Community Manager
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
Regarding List Property

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?

3302
abhilashsawla
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
NPV & XNPV Functions

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

2973
S
S
Newly Minted Pigmenteer
SaiNewly Minted Pigmenteer
asked in Questions & Conversations
Deleting scenarios but preserving data from a child scenario

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?

1031
S
Newly Minted Pigmenteer
Benji
BenjiPigment Academic
published in Career Forum
FP&A Jobs #24 - Mar 23rd

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 positions 1️⃣ [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 for g

1230
Benji
A
Seasoned Pigmenteer
AlexandreSeasoned Pigmenteer
asked in Questions & Conversations
Matching 2 Transaction Lists without unicity

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 1 Thanks for your help ! Alexandre

1322
A
Seasoned Pigmenteer
O
Newly Minted Pigmenteer
OyvindBNewly Minted Pigmenteer
asked in Questions & Conversations
Tracking Outstanding Invoices over Time

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 Date The 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?

1222
O
Newly Minted Pigmenteer
Benji
BenjiPigment Academic
published in Career Forum
FP&A Jobs #23 - Mar 16th

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 positions 1️⃣ [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 comp

930
Benji
E
Seasoned Pigmenteer
ElodieSeasoned Pigmenteer
asked in Questions & Conversations
YTD % in a table

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

5912
E
Seasoned Pigmenteer
J
Newly Minted Pigmenteer
JuliaSpNewly Minted Pigmenteer
asked in Questions & Conversations
Difference between two dates

Hello, I need to create a IF condition that shows : IF date 1 > date 2, then blablabla. Date 1 : Current date, it’s a metric Date 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 :)

5142
J
Newly Minted Pigmenteer
A
Newly Minted Pigmenteer
Armando BittNewly Minted Pigmenteer
asked in Questions & Conversations
How to make semi-additive measures easier to handle?

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 exist However 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 display What needs to happen is:- Calculate sum of A- Calculate sum of B- Divide sum of A by sum of B And 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!!

3661
francois
Employee

Most helpful members this week

Badge winners

Show all badges
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings