Questions & Conversations

Hello, I get a transaction from my ERP with not a specific date by line but a start and a end dateEmployee Project Start End Hours Emp001 Proj1 01/01/2024 05/01/2025 5 Emp001 Proj2 02/01/2024 04/01/2024 2  I need to create a metric with Employee/Project/Day dimensions in which for each dates between the start and end I put the number of hours     01/01/2024 02/01/2024 03/01/2024 04/01/2024 05/01/2024 Emp001 Proj1 5 5 5 5 5 Emp001 Proj2   2 2 2  

If there is a dimension list called “Documents list” , there is a boolean metric A with dimensionality “Documents” list and “Team” It’s a boolean metric which tells the documents are relevant to which all team(s), if a document XYZ is marked checked for “Team 1” and “Team 2”, then in the top page filter while choosing either Team 1/ Team 2 , “document XYZ” row should show upHow to create another dimension list say “Detailed documents” dynamically

Hi! I am trying to apply a calculated item to just one metric in a table and not to all of them. Basically, be able to display this (see photo attached), where I can assign no calculation to some metrics. Do you guys know how to do it?  Thank you! 

Hi! I have a dimension that is currently adding more and more data given that it is being triggered by an import in another tx list. Do you know how I can remove that trigger?  Thank you! 

Hi there, I haven’t really found something related to this topic, hence this new one. I am fairly new to Pigment and have been working heavily with other planning solutions so far. What I see in every project is the need to easily set up parent-child hierarchies for cost centers, profit centers or products. Those can have many levels (e.g. a 10 level deep cost center hierarchy). In other solutions I would get all node and leaf items from a source system and add the respective parent in a separate hierarchy column (so I need to keep two columns maintained to have a full multi-level hierarchy). What is the equivalent of this in Pigment? Thanks everyone! *Update: my apologies, I was actually referring to parent child hierarchies. Would that change the approach?

I want to sum every month; for example I want March 2026 to be the sum of March 2020 + March 2021 + March 2022 + March 2023 + March 2024 + March 2025 (so anything after the actuals month needs to be a calculation of all prior months. Is that possible? 

Hi Team,Is there a way to update the formatting of all parent rows at once?For example, we have data at the Location level in rows, with Country set as the parent. Instead of formatting each country one by one, can we apply the formatting to all parent rows together?I believe this would help us save significant time and effort.Thanks & Regards,Spandan

Has anyone received an error trying to set up an SFTP connection with ADP? It seems to be finding the file OK (we get a different error message if we put a non existent file) but is generating this error in Pigment: “Error while uploading the file. Cannot get the size of '/fromADP/xxxxxxxx.csv'" I’m not sure if it’s a permissions issue or something else. 

Hi everyone,I would like to display both Code and Name of a Dimension, in a Table.Below is the objective which I created from screenshots:In the first row, “CESSION” is the Name of the Code “AU1”, in the “Business Area” Dimension.Thanks !

Is there a way in Pigment to submit a button?(i.e. similar to marking a checkbox as True)

I want to be able to make specific notes about forecasted line items to document the rationale for the forecast.  This would be particularly useful for when a default forecast calculation is overridden to be able to have documentation.  Comments don’t seem to be a viable solution for this, as the comment can only be made on a cell within a grid, and if that cell is no longer visible in the view, (i.e. the switchover date changes and the forecast is hidden and replaced with actuals), it’s not there for anyone updating the forecast to see. I also dislike that comments are permanent and cannot be removed. Has anyone come up with a solution for this that they would be willing to share?

Hi,I have a set of metrics for wich I want to copy the input from one version to another.Version is a dimension ex: Budget 2025, Reforecast 2025….I have in mind something like using the function “ copy input between scenario” but at a version level.Thanks

Hello, Can anyone tell where I am going wrong here? 

HelloCould you please tell me how can sort the below formula so I don’t have the time out formula error ?Formula : roundup(IFBLANK(((('Wallet Lifetime Value'*0.7)[ADD : 'L9 - P&L']-'Input Wallet Upfront'[REMOVE : 'L9 - P&L'])[FILTER : 'L9 - P&L'='L9 - P&L'."Wallet fees"]/ 'Wallet Lifetime'[ADD : 'L9 - P&L'][BY:'SalesForce opportunities'.'Activity level 2'][FILTER : 'L9 - P&L'='L9 - P&L'."Wallet fees"])[FILTER : CURRENTVALUE >= 0],0),2)Thanks

Our current approach uses a formula that pulls department data from a NetSuite Actuals saved search. It looks up the department code and returns the department name if it is in the actuals report. However, for new departments that don’t yet have transactions, the lookup fails—defaulting to “No Department”—even though the department code and name already technically exist in NetSuite.While we can hardcode logic (e.g., map department 239 to a specific name), this isn’t scalable. From what I understand, we can’t create a transaction list that syncs directly to the full NetSuite department list, since that’s not a saved search.One workaround we’ve considered is exporting the department list manually from NetSuite into a Google Sheet and syncing that, but we’re hoping there’s a cleaner solution.How do others or Pigment typically handle this situation when planning for future departments without actuals? IF(ISDEFINED('NetSuite PL Actuals'.Dep

I am investigating using Fivetran to export Pigment data into Snowflake and I didn’t see anything in the Pigment or Fivetran documentation about access to snapshots. Is it possible to export Pigment data from a snapshot into Snowflake?

Hello Everyone,  I have a dimension which is called Supervisory Org which is the Workday hierarchy. In that dimension, I have properties called Level2, Level3, Level 4 etc. which is basically the hierarchy chain.  I am seeing help to develop a logic as to if I select select someones name, I should get everyone rolling up to that person and not only the direct repartees. Not sure if anyone has faced this before. Any help will be appreciated. 

I currently uploaded 2 transaction list containing payroll details. 1 of the report has both Employee ID and Name and the other report only has Name.I’m able to match the names below but i want it to return the employee ID as well, what formula should I use? The example below: I want the 3rd column to return 4068 for Aaron Brethorst.   Thanks in advance!

I have a transaction list with a roster from each month taken on the last day of the month. Sometimes HR would make retroactive changes after the load is done. For example, HR may input a term date on July 1 for someone who terminated June 30. The term date now shows up in the July roster but is missing from June roster. I want to somehow flag that the June roster is MISSING this term date. In the image, Vincent’s term date was captured in July because the term info was processed AFTER the June date was imported. Vincent should have a June term date in the June snapshot, but it is missing instead. In Excel, I could do this:=XLOOKUP(“Snaphot Month”, “Test1 (Term Month)”, “Name”, “Name”, “Term1 (Term Month))This essentially looks up the the employee’s Term month using the snapshot month that is = to the term month (in “Test1”). The result here for Vincent would be blank since there is NO Term month Vincent’s June data. The end goal would to fi

 Hi Pigment Community 👋,I’m working with a table that contains monthly revenue data across several years. My goal is to build a logic that, for each month, returns the latest available revenue value for that specific month, even if it comes from a previous year.🎯 ObjectiveFor each Month (e.g. Jan, Feb, … Dec), I want to retrieve the most recent actual revenue that is available for that calendar month, regardless of the year.Example:Month Latest Revenue Mar Mar 2025 Apr Apr 2025 ... ... Sep Sep 2024 Oct Oct 2024 Nov Nov 2024 Dec Dec 2024 Jan Jan 2025

Is there a way to automatically deactivate Pigment users that have left the company?  

Hi everybody,I am looking for a way to implement a form of circular referencing across multiple blocks. Essentially, I am trying to create a feedback loop like below: This is a snip of an OPEX forecasting model. I want to give the end users the possibility to use the output of a certain forecasting version as the input for a new forecast. That means that users can say: prefill my new forecast with the figures from any of the previous forecasts. I don't think that PREVIOUSBASE() or PREVIOUS() can work, because if I'm not mistaken that only takes the previous value from the iteration dimension. But I want the users to be flexible to choose whatever forecast they want as the base for their new forecast.How can I best go about this? Bas 

Is there an option to apply the conditional formatting on KPIs?

Hello community,I'm looking for a cumulate grouped by Qty. I have a first metric which indicates my need of Qtés per week, and I need a second metric able to detect the week when I exceed the minimum to order. In my example, I have a minimum order of 6. In Line 1 I calculate my requirement per week. (that's done)In Line 2 I want to trigger an order when I've reached at least my minimum order.If I have that, it's already good In an ideal world, I'd have to reduce this quantity to the 1st week, a bit like a moving sum function but with variable parameters. If anyone has an algo idea, I'd be grateful ^^. 

Hi team,  I am trying to cumulate the result for two different scenarios. Can you please help?[Blue] Cumulate in the last period. The result of this formula is in between Feb ‘23 ~ Aug ‘23. I would like to cumulate Feb ‘23~Aug ‘23 and show the total in Aug ‘23. -IF( Month < 'RSU Accounting Data'.'Term Month' AND Month < 'RSU Accounting Data'.'Vesting Month', (PRORATA(Month, 'RSU Accounting Data'.'Amortization Start Date', 'RSU Accounting Data'.'Vesting Date'+1) *'RSU Accounting Data'.'Expense Amortized Future' / 'RSU Accounting Data'.'Amortization # of Days' * DAYSINPERIOD(Month))) [BY:'RSU Accounting Data'.RSU#,'RSU Accounting Data'.EE,'RSU Accounting Data'.Vested?,'RSU Accounting Data'.'EE Active? (Incl. Future Term)','RSU Accounting Data'.'Client Grant ID','RSU Accounting Data'.Forfeit?,'RSU Accounting Data'.Type] [BY: 'Accounting Status'."Reversal"][BY SUM:SHIFT(Mon