Questions & Conversations

Hello,I would like to schedule/automate the refresh of Pigment data in my Excel using the add-in, is there a callable function I can use in VBA to do this? Any ways that people have automated the refresh I would love to hear about.Thanks, Will  

Hi All, I would like to create a process where I build out a new list/add new list items from a metric.It is possible to build new lists from list properties but can this be done by a metric?If so, how?Chris 

Hello, very new to Pigment. I am looking to create a table that shows headcount for CY MTD Act, MTD Bud, MTD PY, Var Act CY MTD vs MTD Bud, Var Act CY MTD vs MTD PY. Then repeat everything for Dec 2026 (compare to Dec Bud and Dec 2025). Looking for a formula to type in the formula bar so this will happen. I worked with the AI chat and it did it for me but the the whole chart was blank

Hi,Id like to take data from a source metric dimensioned by month, GL, department and project and map this into a P&L line item metric dimensioned by month. However, as mapping metrics must be formatted by the dimension of the target what Im unsure how to go about this. In a different life I would create a list derived from the P&L line items and use this to format my mapping table but alas I dont think this is possible with Pigment. Any thoughts on how best to approach this?Thanks,

Hello, I have set up my Edge browser to English  (not English US) and the dates are still displaying with MM/DD/YYYY format.. how to change it?Anybody facing this challenge?  Thanks for the supportRemi.

With the new functionnality to create dimension based on an other dimension/transaction list, I want to create a concatenation of 2 columns in my transaction list but.. Pigment say there is an error because a lot of rows don’t have unique ID. Is it existing a “ISFIRSTOCCURENCE” formula or simithing similar to filter my view and solve the point ? 

HiWould appreciate if some one can share the GreenField BPC Implementation guide lines and the Do’s and Dont’s.ThanksGiridhar

Hi,I have created a table that contains 5 metrics out of which two are in % form using show value as %of metric feature. Thw view that i created is two versions in column and variance also. The problem that i am facing is variance for 4 metrics is coming correct except 1i.e. out of the 2-percentage based metric variance for one is coming correct but other is not though both are using same methods and individually for each version values are coming correct. Unable to find a reason why only one is inconsistent although at individual version level it is coming correct.Please let me know what i am doing wrong.Thanks in advance

Hello! I dropped in a table into another application, and somehow the scenarios are not available to choose. Is there anything I need to toggle on? Thanks for checking! Scenarios shown in the original table: In another board page when I click Scenario: 

Hi,I have a metric named current year with year as data type and no dimension. purpose is to automatically update the current year every year. Is this possible to achieve in pigment and how?Thanks in advance

Hi,I am create a P&L where I have the GL rolling up into a P&L line which then rolls up into a P&L category.However, the GL rolls up nicely into the line item but Im struggling to get the line items to roll into the category. Im using metrics to populate my line items rows and dimensions for GL and Category -  In the screen shot I want the GL 60110 to roll up to Core Processing and for this to roll up to Revenue.  But instead it simply duplicates the Core Processing line.Here are the summary settings - The metrics feeding this table are dimensioned by P&L Line Item (as a dimension), P&L Line item category (property of P&L Line Item) and GLI have mapped GL level data to a line item in a dimension and then mapped this to the individual metrics so I can present it in a table. Please explain how I might be able to achieve what Im looking for.

Hi everyone, I’m trying to export a template from a Pigment table. Right now, the export only shows the headers (Account, Month, Property, Version, Amount) and no rows underneath. I want the full structure to export, including all account rows and combinations, but with blank amount values. Does anyone know how to do this?

Hi, I would like to filter the metrics in a table so I have the option of only showing totals. User would then toggle between the summary and detailed view via a button on a board. How can it be done?

Hi Is it possible to define a cell as in use/active even when the result is zero?I have a filter that distinguishes active cells so can I combine this with the formula so it returns a zero?Thanks,

Hi, seeing as the MCP connection provides the same access rights as already configured in pigment, is there a way to limit that on the MCP side? For example - connecting to claude, the client wants the have the same user rights but no one should have write rights. so Admin would see everything, but won’t be able to change anything (data/structure) from Claude. thanks 

Is there any Pigment function or keyword available to retrieve distinct/unique values?(apart from COUNTUNIQUEFor Example:There’s a metric of datatype “text”.Dimensionality/Structure of metric: Employee and YearSome values for FY 2025 (Source-metric)Employee 1: Country1, Country2, Country3, Country2, Country1 Employee 2: Country7, Country9, Country9Required Output (Target metric) :Employee 1: Country1, Country2, Country3 Employee 2: Country7, Country9  Both the source and target metrics are having same dimensionality.

Does anybody have any advice on on managing the migration of scenario changes back into default plan in a clean way?In other EPMs, multiple scenarios get spun up, different changes are made in each, and then those changes can be cleanly merged back into a main plan without any fuss in the scenario we choose to implement. The deltas are known and thrown back in without breaking any other inputs.We used this functionality a lot when presenting possible plans to business partners and then we would merge the final changes back into plan based on their final feedback.In Pigment, it seems like the copy function is the only mechanism available for this and it seems to hard code all values into chosen metrics rather than targeting the actual changes. We have to choose the blocks and then go app by app sending them through? It’s clunky, but it kind of works for my use case.Further, it seems like I have to toggle “Inputs and imports populate data across all Scenarios” for every default scenario

I have a Transaction List and I want to create a formula that applies logic A when the value in Business Segment Group is value A and uses logic B when Business Segment Group is not value A.  Thanks for the guidance!

Hi,Is there a way to reference the current month value even while using PREVIOUSOF()? Since using iterative dimension is not allowed, is there a way to shift month values so that value returned by PREVIOUSOF() is the current month value instead of previous month?

Hi,Another simple one.I have a Transaction list with monthly data for revenues for customers, product types and dates.I want to create a metric that adds up the revenue based on the dimensions selected for the metric.The dimensions selected are present in the Transaction list.In the formula I type the column I’m looking to aggregate from the transaction list but I cannot see the aggregation differentiate between Business Segments at all.What am I doing wrong? Thanks,G  

Hi I’m trying to do a simple look up using ITEM.I have Transaction list, which contains customer data and the Product Type. Product Type is Dimension data type.I have created a Dimension that allocates each Product Type to a correspondent Business segment, which I created as another dimension.In that given transaction list, I’m looking to add the business segment, I created another column with dimension business segment as data type and I’m using ITEM to bring the Business segment values.ITem('IWSR - NRR Data'.ProductType.Name,'IWSR - Business Segments'.Name)The formula returns nothing and does not flag any errors.What could be the issue?BestG 

Thanks.This is resolved 

It would be great to have a built-in feature that allows users to quickly identify and display only overridden values by applying a formula or filter. This eliminates the need for manual, visual inspection (side- blue bar) of each entry , improving efficiency and reducing the risk of missing changesExample: if there is metric:datatype: “number”  dimensionality: city If there’s a way to quickly identify cities where there is a override (without creation of another formula to compare the values)

Hi All,Do you know how to implement a recursive calculation using MIN() function? Take this metric for example. The goal is that in a different metric I want the minimum value from TEST 1 except that I want the calculation to be recursive. If I am in Aug24, I want minimum value from Aug24-Apr25, if it is Sep24 then minimum value from Sep24-Apr25 and so on.