- - Search the Knowledge Base
Academy
Product Roadmap
Events
Groups

Community
Explore the Community

Explore the Community

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

611 Topics

Recently active

Most replies Most views Newest first

NakulNewly Minted Pigmenteer

asked in Questions & Conversations

Closing and Opening Balance

Need help on how to pull in previous month closing balance in Opening Balance Metric. Closing Balance refers to the Opening Balance. Basically Circular Ref, and just for ref need function similar to previous of Anaplan

6 hours ago

Cedric LJSeasoned Pigmenteer

asked in Questions & Conversations

Combine Previous(month) and BY modifier

Hi,In the below metric with 2 dimensions Month and Version, I try to combine a Previous (Month) and a BY.For now I have the error formula is invalid.The trick I found (please see the second screenshot) is to create a second metric “Other cash test” so I can apply BY .Thanks for your help,

21 hours ago

AdamOccasional Observer

asked in Questions & Conversations

Picking a dimension property dependently on scenario

Hi Pigment Experts, I have the following challenge. I have two properties in a an Employee dimension list (Department_Apr and Department_Mar). Employees may move between departments and these properties are reflecting that. Then I have a metric by Employee which I want to pivot by Department. I use the formula below and it works well. My question is is there a way to write formula so the metrics is either by Department_Apr or Department_May dependently on a Scenario i.e. dependently on input to another metric? The way it works now is that Department_Apr or Deparment_Mar are hardcoded but how to make these values a variable? if('Is Forecast (Headcount)', '361. Total Headcount Cost - A+F') [remove: '01. Payroll Waterfall', '01. Headcount Cost Account'][select: '01. FinType'."P&L"][select: '01. Version' = 'Version Push'] //."Mar Month End"][filter: '01. Employee ID'.OperRepairs = '01. Operations/Repairs'."N" and '01. Employee ID'.RetailTR = '01. Retail Branch / TR'."N"][by: '01. Emp

21 hours ago

Jessica TNewly Minted Pigmenteer

asked in Questions & Conversations

Connector: Gsheet with Pigment

Bonjour, Je voudrais savoir si ce serait possible lors d’un extract de Pigment à Google sheet via le connector de ne pas avoir des lignes vides? Ex: Lors d’un extract avec le connector, j’ai 30.000 lignes et sur ses 30.000 lignes j’ai 10.000 lignes utilent et qui contiennent des valeurs. Cela alourdi énormément les fichiers de travail.Dans les tables (extracts) dans Pigment, il y a une possibilité de filtrer et de mettre (Hide empty rows and columns). Ceci empêche d’avoir des milliers de lignes vides pas utiles.Dans l’attente d’un retour, veuillez passer une belle journée :).Cordialement.TEGUA Jessica.

22 hours ago

MKSMPBBudding Pigmenteer

asked in Questions & Conversations

How to align a property in one dimension with another dimension

Hi, I am looking to combine a transaction list (actuals) with a forecast metric using a cost centre dimension.I have the cost centre dimension in my transaction actuals but in the forecast it is a property in another dimension (property type is dimension and selected as the same one in the actuals). What function should i be using in my formula in order to bring both in combined at the cost centre level?

1 day ago

HarshilNewly Minted Pigmenteer

asked in Questions & Conversations

Show scenario variance and YoY variance in the same table

How can I show the scenario variance and YoY variance in the same table? I’d also like to be able to collapse month » quarter » year as needed. Currently, it’s showing YoY columns for all scenarios. Also, is there a way to restrict which metrics a calculated item pertains to? Lastly, is there a way to hide columns in a table? Thanks!

2 days ago

BenoitCommunity Manager

published in Job Board

The FP&A Jobs Report #79 (Gusto, Chanel, Gong, Spotify...)

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 weekHighlights Chanel [RETAIL] Head of Corporate FP&A 📍London, UK Chanel is a private company and world leader in creating, manufacturing and distributing luxury products. KellyDeli [FOOD & BEVERAGE SERVICES] Head of FP&A 📍Remote, UK KellyDeli is a fast-growing, innovative food company committed to bringing the best of Asia to the world. Qare [HOSPITALS & HEALTH CARE] Head of FP&A 📍Levallois-Perret, FR Qare.fr is a French telemedicine platform that connects patients with healthcare professionals for remote medical consultations. Gusto [HRTECH] Corporate Finance Manager 📍New York, NY Gusto is a modern, online people platform that helps small businesses take care of their teams. Other Positions Gon

310

4 days ago

KevinSeasoned Pigmenteer

asked in Questions & Conversations

Chart Legend Not Displaying Bottom Center

I am unable to properly display the metric in a chart legend below the line chart. The first screenshot has the legend in the bottom right and everything is fine. But when I moved it to the bottom center, the second value is not displayed. This chart is in a second view with one of the metrics hidden so perhaps that is causing the issue. But clearly the data is being displayed as needed but without the proper legend text. Any help to fix this would be much appreciated.

4 days ago

YaejisNewly Minted Pigmenteer

asked in Questions & Conversations

Amortization based on start/end dates

Hi Pigment team! I am trying to setup a amortization schedule as following. Can you please help?Orange is given resources Green is the output that I would like to have in the table/metric Blue is just validation for myself which aligns with the orange Total column and doesn’t need to be in the model Following is the formula I used in excel:For 1/31/2023 Column alone, formula is =($V5/$AS5)*((AV$4-$AQ5)+1) For 2/28/2023 and onwards, formula is =IF(EOMONTH($AR264,0)<AW$4,0,IF(AW$4<=$AR264,($V264/$AS264)*(TEXT(AW$4,"d")),($V264/$AS264))) I tried using the following formula in playground for 1/31/2023 column, but it doesn’t seem to work. IF(Month.'Start Date'=DATE(2023,01,1),('RSU Accounting Data'.'Expense Amortized Future'/'RSU Accounting Data'.'Amortization # of Days') * DAY(Month.'End Date')) Thanks for helping out!

7 days ago

Chris EJust Arrived

asked in Questions & Conversations

NetSuite Balance Sheet - Month over Month Historical

I am trying to rebuild our Balance Sheet reporting from NetSuite into Pigment using a Saved Search. However, because our Balance Sheet is consolidated between entities that use different currencies, the Saved Search transaction amounts do not match the reported amounts in NetSuite by period. This seems to be a difference in currency exchange rate methodologies between the way the Saved Search pulls FX (by transaction) and the way the Balance Sheet report pulls FX (by reporting period). Has anyone been able to solve this and pull in historical Balance Sheets month over month to match the reporting?

9 days ago

Cedric LJSeasoned Pigmenteer

asked in Questions & Conversations

Exclude all the accounts starting by 5123xxxx

Hello,What formula can I use in order to Exclude all the accounts starting by 5123xxxx ?Thanks for your help,

11 days ago

BenoitCommunity Manager

published in Job Board

The FP&A Jobs Report #78 (Gusto, Canva, Feedzai, Geodis, Adobe, Google...)

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 weekHighlights Canva [SOFTWARE] Head of Corporate FP&A 📍San Francisco, US Canva is an online graphic design platform that allows users to create a wide range of visual content. Feedzai [IT & SERVICES] FP&A Director 📍Remote, PT Feedzai is technology company specializing in fraud detection and prevention solutions for financial institutions, payment processors, and merchants. Geodis [TRANSPORTATION] Senior FP&A Controller 📍Levallois-Perret, FR GEODIS is a global logistics and supply chain management company headquartered in France. Gusto [HRTECH] Finance Operations - Pigment System Analyst 📍New York, NY Gusto is a modern, online people platform that helps small businesses take care of their teams. Other P

360

12 days ago

YaejisNewly Minted Pigmenteer

asked in Questions & Conversations

Color formatting

Hi! Is there a way I can change the color setting such that Unbilled and Billed dimensions are in different colors? Thanks in advance!!

14 days ago

jameslJust Arrived

asked in Questions & Conversations

Balance Sheet

Hi,I am trying to build a balance sheet in Pigment.My saved search in Netsuite lists all transactions but, to show the balance, I need to sum all of the transactions from all previous months. How do I do this in Pigment?Alternatively, given I don’t actually need balances broken down by transaction in Pigment, would I be better off to try and find a way of extracting balances from Netsuite so that I can use those? (though I am not sure how I do that so any idea on that gratefully received too)

14 days ago

KarlWCommunity Manager

published in Announcements

Level up your Pigment formula knowledge with new learning experienceNews

Introducing Formula Writing: Unlocking Dimensionality and Calculations We've heard your requests for more formula & calculation training, and we're excited to announce our new Pigment learning path! The training is split into two parts:Read & Interpret Formulas - Perfect for those who need to be able to create inputs and analyze outputs! You'll need just a couple of hours, and you'll be able to better define requirements and understand the calculations available to you. Write & Test Formulas - Hey modelers, this one's for you! This new learning path will offer a deep-dive into the most helpful modifiers and offer real-world exercises to solidify your learning. These new learning paths are NOW LIVE in the Pigment Academy! Click below to get started:START LEARNING NOW

510

14 days ago

keerthanarameshBudding Pigmenteer

asked in Questions & Conversations

Breakdown by same dimension

I was able to Breakdown by Department>Internal Group property for one metric in a table but I’m not able to Breakdown by Department again for another metricI’m able to breakdown by department in either of those metrics but not both. I’m using breakdown option at various places in this table which allows the same dimension to be broken down among different metrics multiple times but not this one specifically. What could be the reason for this?

16 days ago

DmitriiSeasoned Pigmenteer

asked in Questions & Conversations

Scenarios in security metrics?

I have an app with scenarios. Scenarios are enabled:But when I create a metric in security folder, there are no scenarios and values are propagated to all scenarios. But I want to lock/unlock write rights for specific scenarios, so I need scenarios on the security folder too. If I move the metric outside the security folder, the scenarios appear, but then this metric cannot be used in the access rights rules (which is not intuitive).Any tips, thoughts?

17 days ago

RohitDivate_GustoJust Arrived

posted in Job Board

Full time job at Gusto - Pigment Pro (Modeler/Architect)

Hiring for a pigment pro! Please see details in this post where we are hiring for 1 corporate finance role and 1 pigment pro role. https://www.linkedin.com/posts/activity-7183650056133074944-z_oT?utm_source=share&utm_medium=member_desktop

17 days ago

AdamOccasional Observer

asked in Questions & Conversations

NETWORKDAYS function

Hi, I struggle to understand how NETWORKDAYS function can be used. I read the help page for the function but in vain. I want to get number of working days in Jan 2023 (ignoring holidays). My formulas is:NETWORKDAYS(date(2023,1,1),date(2023,1,31),'01. Day of week'.Working = true)where Day of week is a dimension I created (below). I am getting 150 as the result of the formula which is obviously wrong. Help please :)

18 days ago

erikausenNewly Minted Pigmenteer

asked in Questions & Conversations

Repeat row labels

Hi! In the layout selection I can only choose to display grid as tabular or tree. However, both options are grouping the row labels. Is there a way to select Pigment to repeat the row labels?

21 days ago

ybengellounJust Arrived

posted in Questions & Conversations

Help content unavailable

HelloJust to let you know that there’s an issue concerning the help content related to creating a transaction from an import. Check the printscreen below.The redirection button redirects nowhere in typeform.

21 days ago

Adrien LEmployee

asked in Questions & Conversations

Key shortcut

Are any Key shortcuts in Development?A shortcut from Editing to User mode in Board would be helpful, and one for aligning Widget might be great.

22 days ago

Not Jeremy SternNewly Minted Pigmenteer

asked in Questions & Conversations

Aggregate vs. Import for Parent/Child Dimension Relationship

We have two dimensions that have a parent/child relationship - L0 Company and L1 Parent Company. For the exercise, here are some details:L0 has 500,000 items, L1 has 400,000 items This property will be upstream of a fairly complex cohorted revenue model Both dimensions are provided to us from Snowflake The date formatted property “First ARR Date” exists at the L0 Company levelWe need First ARR Date in L1 Parent Company in Pigment, what is the preferred way to do this to maximize performance?Aggregate from L0 to L1 in Pigment using a BY MIN Aggregate in Snowflake & import the First ARR Date into both our L0 and L1 dimensions A third option?Further, would the right way to do this change if the balance of list items between lists changed?

22 days ago

KarlWCommunity Manager

published in Announcements

Pigment has just raised $145M in Series D funding!News

In case you missed it - today we’ve announced that Pigment has just raised $145M in Series D funding! The round was led by ICONIQ Growth, who also spearheaded Pigment’s Series C investment close to a year ago, with participation from Sandberg Bernthal Venture Partners, IVP, Meritech, Greenoaks and Felix Capital. We go into some detail about what we’ve got planned next in this blog post. We would not be where we are today without all of the trust and support from our whole community. We have so much more that we want to do and will use the funds to continue driving innovation to fuel adoption of Pigment. Our co-CEO, Romain Niccoli, shares more details about what we have planned in the blog post - check it out! Eléonore Crespo, co-CEO, Pigment:“Our north star has always been to combine an exceptional product and customer experience, so that organizations can build the right plans and execute on them quickly. This funding puts us in an even stronger position to continue fulfilling this c

600

22 days ago

OlaOccasional Observer

asked in Questions & Conversations

Conditional recipients and Scenarios

I have configured an Automation that triggers in my scenario “Forecast”. The automation contains a conditional recipient, but the issue is that the recipient is defined by my metrics value in scenario “Baseline” instead of the value in scenario “Forecast”. Is this the way it is supposed to work or is there any way around it?

23 days ago

Page 1 / 25

Badge winners

kristian.bartelhas earned the badge Innovator
Sixbert Cyizahas earned the badge Pigment Modeling Fundamentals Certified
klanehas earned the badge Pigment Modeling Fundamentals Certified
Younes YOUSSIhas earned the badge Partner Solution Consultant Certified
Championhas earned the badge Pigment Modeling Fundamentals Certified

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Single Sign-On Need help?

Log into the Pigment Community

Single Sign-On Need help?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.