Skip to main content

Explore the Community

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

881 Topics
I
Newly Minted Pigmenteer
IsabelNewly Minted Pigmenteer
asked in Questions & Conversations
IF function in transaction list

Hi!I am trying to populate a column in a transaction list by using a IF-formula. I want it to say that IF the Fulfillment center name = Start Depot name, then it should be classified as a Fulfillment Center (FC), and if it is not true, it should be classified as a Dip, but I get an error saying “Expressions are incompatible and cannot all be converted to Dimension ('[00] Hub'::'Fulfillment center')”Please see below the formula I am trying and screenshot of my expected result:IF('Act last Mile'.FULFILLMENT_CENTER='Act last Mile'.START_DEPOT_NAME,"Fulfillment Center","DIP")  

5742
I
Newly Minted Pigmenteer
Jeremy Stern
Newly Minted Pigmenteer
Jeremy SternNewly Minted Pigmenteer
asked in Questions & Conversations
Filter Excluding Blank Booleans

Is there a way to filter both “blank” and “non-blank” FALSE boolean cells in one filter?I am trying to filter on check boxes that have not been checked, but however I filter (= FALSE, <> TRUE, etc), it still excludes “blank” boolean boxes, aka boolean boxes that have not been checked yet. Is there a way for a single filter to include both “blank” and “non-blank” FALSE check boxes?

7003
Benji
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
Can we use FORECAST_ETS function for holt & holtwinter forcasting?

hi allCan we use FORECAST_ETS function for holt and holtwinter forcasting calculation?if yes than How?

4381
Keiran
Community Manager
Kyla
Budding Pigmenteer
KylaBudding Pigmenteer
asked in Questions & Conversations
Aligning dimensionality across metrics

Hi Community,I’ve created a Commissions Forecast metric to calculate the difference between YTD Commissions and Total Target Commissions. The value is then spread over the remaining months left in the current year. I’d like to maintain the values from this metric and have it to flow through to my Total Compensation metric which has more dimensions defined in the metric structure. Any tips on how to accomplish this? Commissions Forecast Metric Dimensions: Department, MonthTotal Compensation Metric Dimensions: Department, Month, ID, Employment Type, Employment Status, Location, State. 

4042
Kyla
Budding Pigmenteer
L
Newly Minted Pigmenteer
Lester ChowNewly Minted Pigmenteer
asked in Questions & Conversations
Select specific months

How do I select the first 3 months of each FY?For ex: Revenue [SELECT: Month.Quarter] gets me the revenue for each quarter. but now I want just Q1 in each FY. How do I do that?

5811
abhilashsawla
M
Seasoned Pigmenteer
mmusabSeasoned Pigmenteer
asked in Questions & Conversations
Rolling Average

Hi I have a CPI metric which starts from FY2022-23 and goes on till FY 2121-22. I want to create a rolling average of first 25 values starting from FY2022-23 including FY2022-23 plus next 24 years.Then when it comes to FY2023-24, it does the same thing and include FY2023-24 and the next 24 years. and goes on and on. ThanksMusab

6804
M
Seasoned Pigmenteer
KarlW
Community Manager
KarlWCommunity Manager
published in Career Forum
The FP&A Jobs Report #42jobs

For all the new joiners, a quick reminder of what you get with this newsletter which is sent every Thursday:The 10 most recent job offers from companies worldwide Hand-picked upcoming FP&A events Finds of the Week Subscribe to the FP&A Report here Executive positions Ramp [FINANCIAL SERVICES] FP&A Director 📍NY/ Miami / Remote, US "This role will be responsible for overseeing the company’s growing FP&A function, ensuring we deeply understand our performance, building comprehensive reporting for internal and external stakeholders, and surfacing critical insights to inform intelligent capital allocation decisions across the business. You’ll have regular exposure to numerous cross-functional partners, Ramp’s leadership team, and our investor community." StanleyBlack&Decker [MANUFACTURER]   FP&A Director  📍Miramar / Remote, US "As a Director, FP&A ~ LAG, you will lead the FP&A team for the $830 million LAG business, reporting t

3050
KarlW
Community Manager
T
Newly Minted Pigmenteer
TWestNewly Minted Pigmenteer
asked in Questions & Conversations
Dimension Property

I’m trying to map one dimension in my transaction list to another using the lastnotblank function: ‘Pigment Dealer Model’ is the transaction list and ‘Dealer Type’ and ‘Dealership Id’ are both list properties; sometimes when I use the lastnonblank function it will work and other times, I get the error below: Is there a reason this function would be working sometimes, and not other times? When it works it produces this:  Any help would be much appreciated and please feel free to ask for more detail if needed. 

4812
T
Newly Minted Pigmenteer
Guillermo Puls
Budding Pigmenteer
Guillermo PulsBudding Pigmenteer
asked in Questions & Conversations
Modifying Month dimension in Calendar

Hello Pigment community, Quick one here. I want to modify the Month Dimension in my calendar but “Cannot update a protected property (eg. built-in properties of calendar dimensions)”I’m currently showing Jun 23 (MMM YY) and would like to switch to Jun-23 (MMM-YY).How can I tune my own Calendar?Thanks in advance !!Guillermo

4363
abhilashsawla
M
Just Arrived
Myriem METTAJust Arrived
asked in Questions & Conversations
Fonction pour avoir la valeur des mois suivants

Bonjour,J’aimerai avoir la donnée des mois suivants. J’ai une donnée par mois et j’aimerais calculer une donnée dépendante des 3 mois suivants.  Merci par avance.  Par exemple : 1 257 k€ est la somme des mois de décembre à Février.  

5311
Issam Moalla
Employee
N
Budding Pigmenteer
NachoBudding Pigmenteer
asked in Questions & Conversations
YTD column

Hi!I’m trying to create a new column with YTD figures in a table where we see EBITDA by market.The logic we’re trying to find is to be able to tell Pigment that this column has to be the sum of the actual months and to group it all in a single column.  That is to say, it would be something similar to a filtering option, just as we can filter by month to see the info for a specific month, so that we can choose to see only the YTD figures.The idea is that it would be something dynamic and as we close new months that become current months Pigment would understand that the YTD info has to be updated.

5553
Benoit
Community Manager
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
how we can limit the user for input value?

Hi Community Members,Please let me know how we can limit the user for input value.Means, There is an input metric where user can provide input between 0.01 to 0.99 only.

6659
abhilashsawla
KarlW
Community Manager
KarlWCommunity Manager
published in Career Forum
The FP&A Jobs Report #41jobs

For all the new joiners, a quick reminder of what you get with this newsletter every Thursday:The 10 most recent job offers from companies worldwide (11 this week 🎁!) Hand-picked upcoming FP&A events Finds of the WeekWe share the jobs here - sign up to get the full report with events, finds and opportunities to meet us!Subscribe here: the FP&A Report 📨 Executive positions [SOFTWARE] Finance Director @Mews   📍Remote, EU  "You would lead the company’s funding initiative across both equity and debt dimensions, build, run, and develop the funding strategy of the company enabling the next phase of growth, as well as future senior equity exercises, identify and drive efficiencies across equity and debt dimensions on the balance sheet." [IT & INTERNET] FP&A Director @Workiva   📍Amsterdam, NL / London, UK "Ideal candidates will come with prior experience inside of a SaaS software or technology organization to understand the nature of our busi

1290
KarlW
Community Manager
M
Newly Minted Pigmenteer
M_OlivierNewly Minted Pigmenteer
asked in Questions & Conversations
Creating a week dimension.

Guys, I have a business use case that happened to have a data in weeks, and I would like you to help on how to solve this problem. What are your suggestions..?

5311
Benoit
Community Manager
A
Budding Pigmenteer
AhmedBBudding Pigmenteer
asked in Questions & Conversations
Creating an Access Rights Board

Hi there, More and more people in my company are using Pigment. We have different access rights settings (By Cost Center/ By Business Model/ By Country etc...).Today, I'd like to create a board that allows each Pigment user to see which dimensions they have access to and which they don't.I can of course create a new application by making all accesses available to all users , but I want the user in question to be able to see only his or her accesses.I thought of creating Rights accesses by user ("User A" will have an access Read/No Write only to "User A") but you can not, as far as I know, have 2 similar dimensions in a Metric.Any suggestion?Many thanks

4922
A
Budding Pigmenteer
Rocco
Budding Pigmenteer
RoccoBudding Pigmenteer
asked in Questions & Conversations
Hard Selection on the target metric

Hello Everyone,I have in the following 2 dimension: Year & “Year1”from the FTI formula I hard selected the 200 from the Year.”FY 23”. Year is the only dimensionHow do I hard select on the target metric just one random cell, like the one highlighted below?  

3293
Mat
KarlW
Community Manager
KarlWCommunity Manager
published in Career Forum
FP&A Jobs #40 - July 13thJobs

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🔎 Pigment Finds of the Week🎧The CFO Thought Leadership - Planning Access:Ep 19: Why FP&A Designs the Questions❝The way I think about it is that FP&A really needs to design the questions we’re trying to answer. The data analytics team needs to be able to write the queries to answer those questions. And our data and engineering team has to put the data in a structure that we can query and get value out of it.❞John McCauleyCFO @Calendly JobsExecutive positions 1️⃣ [SOFTWARE]Senior FP&A Analyst @Kyriba, a global SaaS company that provides cloud-based treasury and financial management solutions.You will assist the FP&A global leadership with the development and deployment of financial targets, analysis of financial results, and recommending course corrections to ensure financial targets are met. You will be respon

2670
KarlW
Community Manager
A
Seasoned Pigmenteer
AlexandreSeasoned Pigmenteer
asked in Questions & Conversations
Average counting blank value as 0

Hello,I would like to do the average by counting blank value as 0. How can I do that ?Thanks,Alexandre

4974
N
Budding Pigmenteer
Benji
BenjiPigment Academic
published in Company News
✨ Congratulations to our Q2 2023 Pigment Top Modelers! ✨

Congratulations to our Q2 2023 top Pigment modelers! 🎉Every quarter we award the top 25 of our most active Pigment users with the Top Modeler Community badge 🏆 We’re excited to announce the recipients for Q2 2023 as: @Emilia , @Stephen , @Yaejis , @rschimm , @Morgane Lachuer , @Eda , @Tom_Mace , @JSU , @David S , @lpaul , @AhmedB , @venitiav , @Alice , @Clakss , @Thanh , @keerthanaramesh , @Rares , @Simon , @laura , @Antoine , @sbenkov , @SHUANG , @Gali Baram , @Yannick , @TAZIM  🥳🥳🥳 Thank you for your commitment and exploration of Pigment! It’s amazing to see you so active 👏 I can see quite a few repeat winners on the list! We’ll be back after Q3 with another round! In the meantime, you can spot our expert modelers from the badge ;)

4914
Mat
Benji
BenjiPigment Academic
published in Career Forum
FP&A Jobs #39 - July 7th (OpenAI, Amazon, Vodafone...)

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 weekExecutive positions1️⃣ [IT & INTERNET] FP&A Director @TIER Mobility, the world's leading shared micro-mobility provider.We are looking for a Director of Group FP&A to develop and lead a high profile business performance team. Reporting into the VP Finance (based in London) you will define, design and own core group processes such as budgeting and forecasting whilst also providing business critical insight and strategic decision support to the Group CFO and other C-Level (Executive Leadership) in a prominent role.📍London, UK 2️⃣ [IT & INTERNET] Head of FP&A @Berlin Brands Group, one of Europe’s largest digital companies designing, producing, and selling products.You will lead a diverse FP&A team as part of the Group Controlling and FP&A team. The team works closely with the executive leadership team, prov

3110
Benji
Rocco
Budding Pigmenteer
RoccoBudding Pigmenteer
asked in Questions & Conversations
Mapping Values in different items

Any suggestion regarding oh how to complete the following:I would like to allocate top value in the cells below. In the Loss Utilisation Dash there is 1 metric more (Year Incurred) The formula I used so far is:'03. Future Taxable Income for utilization against available loss' [select: Year."FY 23"][by: -> '01.2 Year Incurred'. "FY 05"]  

2202
Mat
M
Just Arrived
Manon SJust Arrived
asked in Questions & Conversations
Price / Volume effect

Dear community,We would like to create a Price/Volume effect bridge from Budget to Actuals. We were thinking to create a metric for each KPI (Origin Price, Destination price etc.) but that means we create many metrics as the formula use many different KPI for few bridges. Is there a faster way to do it ?Thanks a lot,

1641
Nathan
Employee
G
Budding Pigmenteer
gabmactavishBudding Pigmenteer
asked in Questions & Conversations
Board customization qustions

Hi Community,I’m trying to create some nice boards and have a few questions on presentation elements that I’d like to incorporate, but don’t seem to be possible in Pigment. If possible, please let me know how, or if not possible, if there are any workarounds. Are you able to change background colours on the board, or the font? (for example - we do a lot of our reporting on a black background, so it would be nice to change from the default white. Or be able to align other formatting to our internal reporting themes) Screenshot 1 Can you remove gridlines on a Grid? (again, a lot of our reports are against a black background, so it’s a bit of an eye sore to have the white gridlines there) Screenshot 2 Is there a way to apply cell formatting to a wide range of cells, or a whole table at a time? Currently what’s happening is if I format “Revenue” for example with $ and M for millions, only that one line will change, and not everything that is grouped (Screenshot 3). Updating this has become

2071
Benoit
Community Manager
Rocco
Budding Pigmenteer
RoccoBudding Pigmenteer
asked in Questions & Conversations
Year + 'Metric'

Dear Community,I need to set an expiration year.I am using the formula “Year + 10” on a Metric with only Year Dimension.I would like this to be more friendly to the end user.I would like to set a metric that i can add to year (ex= Year + “metric”) . I tried with a metric with no Dimensions with a value 5. It did not work.The end is for  the user just by changing the metric at the “metric” would change the Expiration Year. 

1844
Benji
J
Seasoned Pigmenteer
JoseSeasoned Pigmenteer
asked in Questions & Conversations
Using LASTNONBLANK with a FILTER OR REMOVE

Dears,I want  to creat a metric or a property dimension where I get the last non blank dimension from a transaction list that also has some constraints like certain dimensions from that transaction list be equal to something. I have the following formula:'01_MRR-T Requests MRR BE'.'Billing Unit'[BY LASTNONBLANK: '01_MRR-T Requests MRR BE'.'Company or Partner Id'][REMOVE:'01_MRR-T Requests MRR BE'.'Product Final'='MRR-D Product final'."Licences"]Is says that I need to add as a dimension  MRR-D Product final, so even if I just want to use it as a constraint do I need to add to the dimensions in the metric structure?  Thank you very much in advance,Jose 

5942
Benji

Badge winners

  • Read and Interpret Formulas Certified
    farhaanadeebhas earned the badge Read and Interpret Formulas Certified
  • Partner Solution Consultant Certified
    Clement Dhas earned the badge Partner Solution Consultant Certified
  • Pigment Like a Pro
    basilhas earned the badge Pigment Like a Pro
  • Pigment Modeling Fundamentals Certified
    basilhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Modeling Fundamentals Certified
    Juliette92has earned the badge Pigment Modeling Fundamentals Certified
Show all badges
Terms & ConditionsCookie settings