Skip to main content

Explore the Community

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

926 Topics
Y
Newly Minted Pigmenteer
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!!   

6915
Y
Newly Minted Pigmenteer
J
Just Arrived
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) 

1721
Lehtohen
Budding Pigmenteer
KarlW
Community Manager
KarlWCommunity Manager
published in Company News
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

2720
KarlW
Community Manager
K
Budding Pigmenteer
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?

2392
K
Budding Pigmenteer
Dmitrii
Seasoned Pigmenteer
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?

2185
Benoit
Community Manager
R
Just Arrived
RohitDivate_GustoJust Arrived
posted in Career Forum
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

1180
R
Just Arrived
A
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 :) 

4945
CDALMAY
E
Budding Pigmenteer
erikausenBudding 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?

2082
E
Budding Pigmenteer
Y
Just Arrived
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. 

842
Keiran
Community Manager
KarlW
Community Manager
KarlWCommunity Manager
published in Company News
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

1290
KarlW
Community Manager
Ola
Seasoned Pigmenteer
OlaSeasoned Pigmenteer
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? 

2121
Benoit
Community Manager
S
Newly Minted Pigmenteer
Sean R.Newly Minted Pigmenteer
asked in Questions & Conversations
SCIM and User Creation

Will manual user creation/invitations be made unavailable for users inside the domain when SCIM is enabled?Current security/administration issue we are facing:Security Admin Role is being overly used and assigned for the impersonation feature. This is used for troubleshooting issues with Clients/Users for application/model building. Is it possible to change the level that requires this access in the future? With SSO enabled we still have users attempting to invite or manually create users with internal Domain accounts.We need to confirm that the SCIM security constraints are not circumvented with users being able to create/invite internal domain users.

2752
Benoit
Community Manager
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
# of months in between two dates

Hi Pigment team,  Is there a way to get difference of the two dates in # of months?Normally in excel, following is usedDATEDIF(EOMONTH(A date cell,0),EOMONTH(B date cell,0),"M")For example, the # of months in between 1/31/2017 & 2/29/2016 will be “11”.   Thanks in advance for looking into it!  

3272
Y
Newly Minted Pigmenteer
D
Seasoned Pigmenteer
DastanSeasoned Pigmenteer
asked in Questions & Conversations
Trend Line

Hi Pigment Community, Is there a way to insert a Trend Line on a chart similar to Excel? For instance, here I have a chart, which is trending slightly upward. 

1882
D
Seasoned Pigmenteer
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
Building a balance sheet in pigment

I am trying to build a balance sheet but I did not find any article about it.So i create a saved search in netsuite that is linked to metric in Pigment by using a transaction list.I’m trying to display data for multiple periods ( ex: dec 21, dec22...) in the same metric but looks like i have to create different transaction lists for different periods and then create a table to aggregate all the periods.Happy to have your insight on the most efficient way to build a balance sheet,thanks

3111
BrunoRodriguez
Employee
Benoit
Community Manager
BenoitCommunity Manager
published in Career Forum
The FP&A Jobs Report #77 (Moonfare, Demandbase, Webflow, Lego...)

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   Moonfare [FINANCIAL SERVICES] Strategic Finance Manager 📍Berlin, DE Moonfare is a digital platform leading a new era of private equity investing.   Demandbase [SOFTWARE] FP&A VP 📍Remote, US Demandbase is a B2B marketing technology company that provides an account-based marketing (ABM) platform.   Oscar Health [INSURANCE] Senior FP&A Director 📍New York, US Oscar Health is a health insurance company that operates primarily in the individual and small group markets.   Five9 [SOFTWARE] Strategic Finance Director 📍San Ramon, US Five9 is an industry-leading provider of cloud contact center solutions.  6sense [SOFTWARE] FP&A VP 📍Remote, US 6sense is a B2B predictive intelligence platform that helps businesses identify and prioritize potential buyers b

860
Benoit
Community Manager
MKohli
Seasoned Pigmenteer
MKohliSeasoned Pigmenteer
asked in Questions & Conversations
Is there a way to default page selectors in an application?

Would like to default the page selectors in my application to dynamic display as opposed to default. Is there a way to do this without manually adjusting every view?

2142
MKohli
Seasoned Pigmenteer
Dave L
Newly Minted Pigmenteer
Dave LNewly Minted Pigmenteer
asked in Questions & Conversations
Google Sheet connector and date format

We are pulling data from a view in Pigment into Sheets via the Pigment Connector and have noticed that the date information that is pulled does not necessarily reflect correctly.The month in Pigment, for instance, shows “Jan 24”.  However, when this data is pulled into Sheets via the connector, the actual underlying date comes over as 1/24/2023 (which would be January 2023, and not January 2024).  Is there a known way to account for this disconnect in dates between the month in Pigment and the way that gets translated into Sheets?  Below are a few screenshots to illustrate the point:  January 2024 date in Pigment translates to January 2023 in Sheets via the connectorJanuary 2024 date in Pigment translates to January 2023 in Sheets via the connector 

2793
J
Seasoned Pigmenteer
J
Newly Minted Pigmenteer
Jacques d. S.Newly Minted Pigmenteer
asked in Questions & Conversations
Pull a dimension based on a number metric

I everyone,Do you know if there is a way to pull a dimension based on a metric ?Here is what I would like to do :I have a dimension that has :An ID number column from 1 to 1000 (manually filled) A Country dimension column (that I want to fill with a formula) A Month dimension column (that I also want to fill with a formula) An Activity dimension column (that I also want to fill with a formula)On the other hand, I have a number metric with the tree dimensions Month, Country and Activity, with an input based on a formula that gives me numbers from 1 to 1000.So in my dimension I would like to affiliate the month and the country regarding the column number, matching with the number metric. I tried Match and Item functions but it is not working.Do you know if it is even possible with Pigment ? Thank you for your help !  

1312
J
Newly Minted Pigmenteer
S
Newly Minted Pigmenteer
Shane CrinesNewly Minted Pigmenteer
asked in Questions & Conversations
Automatic feed for SOFR Forward Curve

I am looking to find a way to setup an automatic feed for 1-month SOFR future rates in order to better forecast variable interest rates. Does anyone have any experience with this or have any recommendations?

751
Nathan
Employee
Thu Mai
Thu MaiKeen Learner
asked in Questions & Conversations
Native Scenario

Hi Pigmenteers 🤗I have 2 questions related to Pigment’s native scenarios:1. What are the main benefits of using native scenarios instead of custom scenario list? 2. I also learn that once you enable native scenarios in Pigment, the native scenarios will be applied to all the metrics in the application, is there a way we could remove it out of some specific metrics? 

1812
Thu Mai
G
Newly Minted Pigmenteer
Gali BaramNewly Minted Pigmenteer
asked in Questions & Conversations
Calculating MovingAverage() treating blanks as zero's using ISDEFINED() times out

Hi,I’m trying to calculate a moving average where blanks are counted as zero’s. When trying to leverage the “is defined” formula I get a calculation time-out error. Please advise.

3176
G
Newly Minted Pigmenteer
A
AdamOccasional Observer
asked in Questions & Conversations
ADD vs BY

Hi Guys, I have a beginner’s question. I am not entirely sure I understand the difference between BY and ADD. I understand both can be used to split the data into additional dimensions but not sure when I should use which. For example - I have data by Period and Account. For the purpose of dimensions alignment with other metrics, I need to add Channel and Country assuming the same values for Channel and Country per Period and Account. I know I can use BY or BY CONSTANT but what if I use ADD? What would be the difference? Regards,Adam

6463
francois
Employee
P
Newly Minted Pigmenteer
PetterNewly Minted Pigmenteer
asked in Questions & Conversations
Error: Function error: function IF argument 2 and 3 need to have the same type

Hi!I’m having issues with a formula. My formula is currently looking like this:The result I get is the error message Function error: function IF argument 2 and 3 need to have the same type. Any idea of what I need to do to get the dummy name in the CC# column?

3104
Issam Moalla
Employee
P
Budding Pigmenteer
PatMacBudding Pigmenteer
asked in Questions & Conversations
Conditional Formatting - How do you override specific cells with static formation?

Is there a way to apply conditional formatting to a column/row with the option of removing the formatting on specific cells within that column/row?In the attached example, I would like the bottom row to not be subject to the conditional formatting. 

1362
P
Budding Pigmenteer

Badge winners

  • Read and Interpret Formulas Certified
    FelipeFonsecahas earned the badge Read and Interpret Formulas Certified
  • Pigment Like a Pro
    meghrajhas earned the badge Pigment Like a Pro
  • Pigment Modeling Fundamentals Certified
    meghrajhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Modeling Fundamentals Certified
    JamesMhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    JamesMhas earned the badge Pigment Like a Pro
Show all badges
Terms & ConditionsCookie settings