Explore the Community

Hi Team,Can anyone help me to define security for a Boolean.In my use case there is a requirement that user can select only one scenario (3 scenarios created in a dimension) for each country and product family. Thanks in advance  

Hi here,The possibility to Push Data from Gsheet to Pigment is very useful, thanks.However, when pushing the informations, it seems that the line are being added to the previous lines and not replacing them.For example, if someone is reviewing his budget in Gsheet and we want to push the information in Pigment, new figures will be added the previous pushed figures.Is there a way to “update” the Named_Range and not adding it? Thanks

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 +  Upcoming FP&A EventsExecutive positions1️⃣ [TECHNOLOGY, INFORMATION & INTERNET] Head of Financial Reporting @THG, a fast-moving, global technology business that specializes in taking brands direct to consumers.You will be reporting to the Group Financial Reporting Director and support across our financial reporting and Group finance function. You will have a strong financial reporting skill base, able to support across UK and global compliance, lead the THG PLC Group audit along with supporting on one-off projects as they arise. Sitting at a Group level, you will see all divisions of the business and work closely with our commercial teams, tax, treasury, and investor relations, you will therefore be someone who is personable and keen to build strong relationships and networks across the business. You will have strong pro

Hello!Can someone please help me to upgrade the following formula?I would like to add following statement: “If there’s [N/A] in the job name, (blank) result in the ‘Model FCST Month Dimension’ property.IF(ISBLANK('[FCST] Greenhouse List'.'Start Date (Offer) Dimension'),IF(ISBLANK('[FCST] Greenhouse List'.'Manual Input'),'[FCST] Greenhouse List'.'Forecast Start Date Dimension','[FCST] Greenhouse List'.'Manual Input'),'[FCST] Greenhouse List'.'Start Date (Offer) Dimension')Thanks in advance!!   

Hi, I am looking for a way of using the filter function with two conditions. Example: Looking for a sum of specific accounts and cost centers. lets say for accounts: 400,401 and 406 and from cost centers 21;1000;1150;1321;1400;2321;2400.I am already using the filter to look for the sum of the accounts, but found out that I need it on specific cost centers as well Any ideas how to solve this? :) - Benedikte

Welcome to our May Customer Connect, where we bring Pigment customers together to share knowledge and best practices around a particular topic!  “If a cell was updated in the forest with nobody there to see, did it really happen?“ - FP&A Analyst, probably 🤷‍♂️ It’s been a few months since our last Customer Connect, but we’re back at it again – this time focusing on Collaboration! Customer Connect will take place on Thursday 25th of May at 15:00 (CEST). This month is all about collaboration: a key priority for you, and therefore for us. This is why we'll soon be launching exciting new features, so tune in for a sneak peek! 👀 Not only will you be hearing from fellow customers, we’ll also have Pigment’s product experts on the call. In the session we’ll be sharing and discussing all things comments, access rights, automations and more. Ultimately, you'll leave this month's Customer Connect with actionable insights on promoting collaboration in a controlled way within your workspace. 

Hi everybody. I’ve come across a task to post one metric to a dashboard in the form of several graphs each of which will show the only element of a dimension. Let’s say we have different networks: 2g, 3g, 4g in a single metric. I need three graphs to show traffic per network type: The first one should be 2g traffic, another one - 3g, the last one - 4g.They should not be synchronized by this dimension (‘Technology’ dimension on the graph). How to properly do it? Thank you.

Hello, What is best way to setup the metric formula to summarize the # of headcount by following three?by Division (using Division property) by monthly (using Effective date property. This is basically monthly HC Data exported date.) by Worker type. (using Worker Type property)  Thanks in advance! 

HiCan we provide Write access to Boolean data type?if yes, please let me know how.

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📅 Upcoming FP&A eventsExecutive positions1️⃣ [FINANCIAL SERVICES] Head of FP&A @Dojo, which empowers businesses by creating the tools and technology that turn transactions into meaningful relationships.You’ll join our newly established Strategic Finance/FP&A team which is a high-performing, specialized group working directly with the Exec team and Founders. As we enter into our next phase of rapid growth and prepare for imminent international and product expansion, it is more crucial than ever for us to ensure we scale in a commercially sustainable way. As the Head of FP&A, you will report to the Director of Strategic Finance with a high level of autonomy and responsibility, and exposure to our executive and senior leadership teams and influencing decisions. This is a 16-month FTC covering maternity leave, and as we

I’m having issues properly showing the growth and variance of negative items.As an example, if actual EBITDA was -0.25 and budget was -1.0, I can get the difference to display correctly, but my only options for % variance are-75% (-.25- -1.0)/-1 or  +300% (-1- -.25)/-.25Neither of those are correct.  It should be +75%.  I can use “Reverse Signs” but that doesnt apply to conditional formatting.  Has anyone figured out a better way to show this in a table?

Dear all,Can you please help me with this function? I keep getting the error note.  I am trying to say IF(X or Y then) and IF(A or B then).The function is as follows:  

Hi Team, As we know pigment is all about visuallization, how interesting and convenient we can make board for the end user and visually appealing . On community we have article on Board Inspiration also where we get tips on board preparation but it would be more helpful if we could have some pictorial representation of how we can make our board more eye catching and sensible for end user at the same time. It would be preferred if we could have some sample images of recommended board. Or is there any article on the same which i may have missed than kindly help me locate that. Thank you in advance

Hi Pigment Folks, I have the following FX conversion rate challenge,ContextI build my Balance Sheet from staging transaction amounts in local currency from Transactions list and structuring the amounts over a hierarchy were account number is the lower level.My problem comes when trying to convert the amounts to our reporting currency. - I have a metric where I input the conversion rates on a monthly basis. - The balance sheet has the following behaviour: Every month, the cumulative amounts should be converting to the latest rates. And every year should be converting to the last month of the year rates.ChallengeI’m looking to create an FX metric that I can apply to the staged amounts that it’s flexible.I mean that whenever I’m showing data by years, quarters and months select the right rates.For years would multiply the staged cumulative amounts by last month of the year rateFor month would multiply the staged cumulative amounts by each month ratesFor quarters would multiply the staged

Hi Team,Please suggest me a way to calculate the difference between Income (List item) and Total Expense (Calculated item) in order to calculateate EBITDA.Screenshot attached below for your reference. 

Hi I Have created a table, but an Empty Row is getting added there with data and not getting any Error while applying formula. Please help to solve this problem and Screen Shot is attached here for your reference. 

Hi Community, Wondering if someone has been able to manage counting unique customers for a metric dimensioned by customer & product.We have an ARR Metric defined by Customer ID, Product and Month. I would like to have a count by month of the unique customers which have an ARR value. The standard approach using the formula below is effective in having total customer accounts but I am then unable to filter on the products available. IF('Ending ARR'[remove sum: 'Product Type'] <> 0 and ISDEFINED('Ending ARR'[remove sum: 'Product Type']), 1 , blank)I worked to try and resolve this issue by leveraging the below formula which does allow me to filter on products and not double count total logos but when filtering on a single product the number becomes understated. Exec filtering on a product that is part of a set>1 would yield 0.5 or 0.33 vs 1Switch(IF('Ending ARR' <> 0 and ISDEFINED('Ending ARR'), 1 , blank)[remove sum: 'Product Type'],  1,1,  2,0.5,  3, 1/3)*IF('Ending AR

Dear all, I have been trying endlessly to import data into this transaction list, but we get this error message of excluded values from the CSV source. We’ve already imported data into other lists and it’s the first time we get this error message so I was wondering if you could help us with it.Here is the error messagethe excluded data was supposed to be added on properties that are dimensions. The data we’re importing is very simple text And the dimensions already exist on Pigment, we’ve already created them.I would really appreciate your help dear Pigment Community!

Hello, I want to create a if function, in which the logical test is a contains function. If the result from contains function is TRUE => put a value from a dimension, if the result is FALS => put another value from a dimension. I tried to do that like this (in a column dimensioned into FF_fg_non_Ankorstore, supporting the logical test): IF((CONTAINS("FF",TL_OLC.'Lb Charge Type')=  TRUE,FF_fg_non_Ankorstore."FMV",FF_fg_non_Ankorstore."AKS") But it is not working. Could someone help me on that ? Thanks a lot!

Hello,Is there a way to compare easily Scenario between them ?E.g: I want to compare Budget 1 vs Budget 2 with variation (value and %). But I also want to compare Budget 2 vs Budget 3 the same way and I don’t wan’t to create another view with another calculated item, because I have numerous scenario to compare.The idea is to have a var (value and %) between 2 scenario by selecting them. Is it possible ?Thanks

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️⃣ [FINANCIAL SERVICES] FP&A Growth Director @EarnIn, a financial technology company.We are looking for an experienced professional to lead finance for growth, partnerships, and new product development. This individual will partner closely with the executive team and other leaders to set and support our growth strategy, design and optimize new products, allocate resources, optimize performance, and bring a financial lens to investment decision-making.  The role will report to the Head of FP&A.📍Bay Area/Remote, US 2️⃣ [RETAIL APPAREL & FASHION] FP&A Overhead - Omnichannel @PVH Corp, the growth platform for Calvin Klein and TOMMY HILFIGERThe Omnichannel Finance and Controlling team supports the department in reaching their targets by managing the short, medium, and long-term planning, control, and

I can see the page options for metrics and graphs that allow filters to be linked to the same as the board. However is the same available for Transactions lists?  Many thanks!

Hi Can we define condition formatting based on metrics?

I have a transaction list with a property that is filled through a dimension list with a month, this transaction list has also another property where I want to aggregate the latter property that is filled through the dimension list (month) and a number metric containing the number 2. But I get this error message “ Expressions are incompatible and cannot all be converted to Dimension (Month)”.My end goal is to have my needed property with the property containing the month dimension + 2I don’t want it to be done manually so I want it to be added to this metric containing the number 2.I hope my question is clear. I am impatiently waiting for your feedbacks!

Hello!  I am trying to summarize the cost by department and division by monthly basis using transaction list from another app. The setup is set as how I would like to see but the sum of amount is not same as what I expect. Can you please help? Thanks in advance! This is the logic I used to create a metric:'PL GL Data'.'Net Amount (USD)'[BY SUM:'PL GL Data'.'PL L0','PL GL Data'.Division,'PL GL Data'.Department,'PL GL Data'.Month][FILTER:'PL GLs'.'PL Cat 1'='PL Cat 1'."Headcount Costs"]Here’s the PL GL Data transaction list. For sanity check, I filtered out “Headcount Cost” for PL Cat 1 and March 2023 transactions only. Total should be $9,100,788.45 but I am getting $9,124,046.48