Connect with other users, discuss how you're using Pigment, and get inspired
Recently active
I have the formula below: (('EE_Comp_01_SabbaticalAccrual_P&L_ReAllocated' * EE_BU_AllocationFinal )[BY: -> EE_Card_Department,EE_Card_SalaryCurrency, 'EE_Card_P&L', 'EE_Card_Direct/Indirect'])The highlighted in red, assigned my employees to the department that they belong for each month based on that metric. INSTEAD, I would like to just assign them to the last department they belonged to for each version. I tried inserting “BY LASTNONBLANK: → “ but it did not seem to resolve the issue. See screenshot for the stracture of the EE_Card_Department below: Basically I want to adjust the formula above, to assign this employee only to department FBS Revenue. Any ideas?
Hello,I have this figure: and I need to make this calculation → Q1= (1,28+0,72)/3. But I don’t have this option in the calculated item. Can you please help me. Regards,
Hi, is there a way to import list items of one list into another list?
Can we group a list of actions in pigment into a process (Just like we have in Anaplan)? Is there such a capability?
Hi, I’m working on a board that uses complex security and I want to limit the items in the page selector. The security model is based on cost centres and employees, and others.I want to display those employees in the page selector that match certain criteria (employee.criteria = true). For this, I have created a metric and used it as a dynamic variable (Technical Employees), then assigned it to the page selector.Due to the security model, some users will have no access to given employees, and therefore the metric used for the variable will return nothing, which is correct.However, in this situation, the board ignores the variable in the employee page selector, and incorrectly reverts to displaying all items to the user: Suppose I don’t use the variable in the page selector, but manually select the employees that match my criteria in the Available items. In that case, the page selector will return an empty result if the user has no access to those employees, which is the expected behavi
Hello Pigment community,Is there a option where when we select an item of a dimension in one metric or table, the other metrics and tables get synced with that item only and display data of that item specifically?
Hello,I’m trying to make this calcul to keep only the value on the last month of the quarter:'EE_Ramping Employees' [By lastnonzero: '[01] OBROC_DATA HUB'::Month [FILTER: '[01] OBROC_DATA HUB'::Month.Quarter <> '[01] OBROC_DATA HUB':: (Month + 1).Quarter].Quarter] But I got this error message: Can you please help me. Regards,Rockney
Hi everybody,I have a grid with two time-dimensioned calculated items. One is YTD and one is YTG where they cumulate using the selected month: YTDYTGThese work fine, but I also want to create a calculated item that shows the sum of both YTD and YTG (i.e.: full year). I couldn't get it to work via calculated items in the same grid, so as a workaround I made a second grid that shows the full year P&L. Although that workaround is okay-ish, I'm sure there must be some (better) way to get Month | YTD | YTG | FY in the same grid?Thanks, Bas
Struggling to figure out how to set up a formula properly. I’m trying to create an IF statement with a condition where it looks at a transaction list property with X dimension and if it matches to a boolean metric list where X dimension is flagged as TRUE then return A otherwise B.Transaction List = PL_Transactions Transaction List Property = PL_Transactions.Vendor Dimension = Vendor Boolean Data Type Metric w/ 1 Dimension (Vendor) = Draft_Vendors
Hello, is there a best practice to rebalance forecasts to hold to the beginning of the quarter’s forecast. For example, if on Jan 1st, I forecast to spend $12k for Q1 ($4k per month) and then when I get to Feb 1st, I actually spent $6k in January. I now manually take $12k - $6k = $6k / 2 = $3k, and then I forecast $3k for each February and March each to hold the $12k for the entire Q1 forecast + Actuals. Is there an automated way (not manually doing the math and re-entering for the remaining months) to do this?
Hello Pigment Community,I need help with automating calculations for specific brands in Pigment. Requirement: For the brands marked (e.g., checked/true), I want Pigment to automatically calculate the values. For the unmarked brands (e.g., unchecked/false), I want to manually input the data. Goal: I would like to filter the view to display only the unmarked brands (those marked as false), so I can easily input data manually. Thank you for your help.
How do you compare to your peers? Where are they placing their budgets? Which skills do they value the most? We surveyed 2,500 leaders (70% director or above) on the most pressing issues in the profession. The headlines this yearDespite tighter budgets and economic uncertainties, opportunities for growth exist with smarter, customer-centric revenue operations.The risk landscape remains varied and complex - however, businesses are broadly more positive about the outlook compared to last year. Finance continues to evolve, with data and analytics playing an increasingly critical role. The growing skills gap presents a significant challenge which companies are trying to address. Most companies are 2-3 years away from being able to truly leverage AI, despite broad excitement and optimism. Those that do will have a real advantage.Drilling downThe report is split into four parts: a retrospective on the past year, predictions about the year to come, AI strategy, and the evolution of the role o
I have a metric dimensioned by Day and Project. I want to offset back a certain number of Days based on another Metrics Input (Project Length). The Project_Length metric is an integer metric dimensioned by Project only. Is there a way to dynamically offset the number of days back in a SELECT statement based on an input such that this? I have several projects that start N number of workdays before the end of the month, so I am trying to calculate their start date for each month based on the number of days they take (Project_Length)
I have calculate the First Workday on the Day Dimension and want to look up that date on the Month dimension. How can I lookup the First Workday on the Day dimension from the Month dimension. Screenshots below:
I took a snapshot of an application by selecting the scenario named “Current.” However, when using a table, I am unable to see the edit icon to rename the scenario from "Current" to "fcst." Could you help me understand why the edit option is disabled and how I can enable it?
I want to show a calculated item that takes the difference (A-B) of two scenarios on a chart, but remove the underlying metric that it is calculated from. I have tried using ‘show values as’ vs calculated item but there’s no option to show value as the difference of two scenarios. I also tried duplicating the metric and multiplying the duplicated metric by -1 to offset the initial metric via show value as > difference of metric, but this removes everything including the calculated item. I also tried the filter workaround as explained here, but this also removed everything including the calculated item. Any help here would be appreciated!
We kicked off 2025 with a bang and are ready to share even more exciting product features with you this month, along with a big announcement and upcoming events for you to join this year. ➡️ Pull formatted data to Excel 🎨 Expand your Workspace Color Palette 🔎 View and manage Snapshot usage 🔒 Secure your API Keys with IP Allow lists ℹ️ Manage new Applications' access rights inheritance 📉 Highlight top contributors in Variation Waterfall charts 🏆 Pigment Awards: shortlist announced ⭐ Help us feature in the Gartner® Magic Quadrant™ in 10mins 🌐 Product Webinar & Virtual User Group 🥐 Paris Roadshow & User Group 🗽 North American Roadshows & User Group 👥 Join Pigment Community groups and megathreads 💰 Sales & territory quota planning webinar Pull formatted data to Excel With the new Include View Format option in the Pigment Excel Add-in, you can seamlessly transfer formatting from your Pigment Views to Excel spreadsheets, reducing manual adjustments and saving time
Hi all, I'm wondering if any of you can help me with some conditional formatting logic. It should be quite simple: I want to create a conditional formatting rule that only changes the font colour and not the fill. The reason is because I already have certain fill colours for the subtotals in my table (i.e.: margin, ebitda, etc.) and I don't want to override the fill colour for these subtotals. So my conditional formatting should only change the font colour instead. Is there any way to do this? I’ve tried using the ‘transparent’ fill colour, but that doesn't help.Any help is much appreciated!
Hi, I’m trying to create a rolling TTM for Net Income and to store it by Quarter. Rolling TTM stored by quarterI’ve tried using a TTM by Switchover month metric, but that only gives me a single period of data at a time. However, I would like to show the TTM trend by quarter on a graph so I need to store the amounts by quarter. Can anyone assist in the best approach for this? Thanks in advance, Jeff
Hi Gang,We completed the 2025 budget process and archived the data in both a snapshot and saved data metrics across multiple apps. I’ve created a budget restatement capability for OPEX and CAPEX, which was relatively straightforward since it’s essentially a register of debits and credits.However, we’re facing significant challenges in building something similar for workforce (WF) management. The complexity arises from various factors: positions can transfer between departments, new positions can be approved, and we also need to adjust other fields—such as termination dates—to backdate and align with planning done outside of Pigment. WF is particularly challenging due to the downstream calculations involved, including benefits, payroll taxes, bonuses, etc. We can’t simply input new headcount (HC) numbers and dollar values, as we rely on the model to perform these calculations.Has anyone developed a budget adjustment capability for workforce management? If so, what did it look like?
I have a table with data displayed quarterly across the columns. The data in the metric I am using is dimensioned by month, and I am using Month > Quarter as my primary time dimension in the table. I also have a Month > Year dimension stacked on top of the quarter. I use the Sum aggregator on the quarter to display annual totals. When I collapse the year, the totals go away and the entire column is blank. How can I display annual totals when collapsing the year?I have other tables with the same time dimensions/aggregators, and the annual totals display correctly when collapsing the year so this seems like it might be a bug?
Hello, Is it possible to add images from sharepoint/onedrive ?I have added the sharepoint link in approved domain, but when I use an Image from the sharepoint, I am unable to view the image in Pigment. Please advise. Thanks,Apurv
I have a Date Type metric dimensioned by Project and Month. The “Project” Dimension has an Integer Property of “Relative Completion Day”. Number of Days can be positive or negative.I am attempting to calculate a date based on adding “Relative Completion Day” property to the First Workday of the Next Month (M-F). Below is an Example of how it would Ideally Work.What would be the best formula for this? I have also screenshotted my Day dimension. Project Dimension: Calculated Date: (2/3/2025 + (-3) = 1/29/2025) ; 2/3/2025 is the first workday of February - 3 workdays before that. Day Dimension:
I am trying to calculate the number of working days in a month using the NETWORKDAYS function but it simply returning the number of days in the month. Am I using this incorrectly?
Hello All,I currently need a bit of help with allocations. I want to create a rent schedule where the yearly rent amount needs to be allocated based on the yearly contract (start and end date). Just to clarify, one store code can repeat multiple times due to different contract years. Rent type is just used to differentiate between office and stores.
Already have an account? Login
Single Sign-On Need help?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.