Unanswered questions

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 ? 

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,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 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?

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