Skip to main content

Questions & Conversations

Got a question about your models? Want to start a discussion? It's here!

  • 813 Topics
  • 2,194 Replies
813 Topics
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
Required Detailed example of Textlist Aggregator

Hi,I would like to understand Textlist aggegator in detailed.Where or how to use it in different - different scenario. 

3214
P
L
Just Arrived
Laurence TemamJust Arrived
asked in Questions & Conversations
Pennylane

Hello, we have an affiliate using Pennylane. Have you already implemented the API to import the general ledger into Pigment ? Thanks

601
R
Employee
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
Remove duplicate leads

Hello,I Have the below list of leads and I want to count 1 in the column Count only for the lastest lead of the company.The goal is to remove duplicate leads of my lead analysis.Thanks  

601
Stef
Employee
K
Budding Pigmenteer
Kamil SobczakBudding Pigmenteer
asked in Questions & Conversations
Cancellation rate allocation

Hey team, I’m trying to get a dynamic metric where based on the age of added employees I can schedule cancellations as per assumed % however I’m getting an error I can’t solve. TMs_02_Employees_New is a basisCancelled Timing is a dimensionthen assumption and mapping schedule for months. Can you please help?   

1164
Stef
Employee
V
Budding Pigmenteer
venitiavBudding Pigmenteer
asked in Questions & Conversations
2 scenario + 2 year variance

Hello,I am trying to have a P&L comparison with a scenario A on 2024 vs. a scenario B on 2025. Is it possible to have a column scenario A 2024, a column scenario B 2025 and a third column with the variance between both ? When I try to do it, I have 2 columns per scenario and per year and it’s hard to read. Thanks

2404
Jérémie
Employee
O
Newly Minted Pigmenteer
Olga VovkNewly Minted Pigmenteer
asked in Questions & Conversations
How do I save sheet view formatting?

I am hiding some rows on the sheet view, but every time the board gets refreshed, it reverts back to original formatting with all the rows visible. How can this be fixed? 

2195
Jérémie
Employee
D
Newly Minted Pigmenteer
Dastan S.Newly Minted Pigmenteer
asked in Questions & Conversations
Using lagged month in Iterative calculations

I was working on Headcount planning and in order to be able to calculate attrition, I used iterative calculation functionality. With that I was able to calculate Attrition by multiplying attrition rate to ending (beginning) headcount, which is, in its turn, calculated as Beginning Headcount plus new hires minus attrition.Now I want to add Backfills to the calculation, so Ending Headcount will be Beginning Headcount plus new hires minus attrition plus backfills. I am calculating backfills as % of Attrition, and Backfills is also a part of Iterative Calculations. The thing I want to do, but cannot, is being able to instead of current period’s attrition get 2 months’ prior attrition and multiply it by backfill rate. So, if for instance Jan 25 attrition is 100 FTEs, my Mar 25 backfills should be 100 * 90% (Backfill rate) = 90 FTEs. So, instead of having 90 FTEs backfills in Jan 25, I would like to have it in Mar 25.I tried to put [SELECT: Month - 2] in the formula for Backfills metric:(Att

1152
Nathan
Employee
B
Newly Minted Pigmenteer
Ben KingNewly Minted Pigmenteer
asked in Questions & Conversations
SUM Previous Year to apply Growth Rate

I am trying to get the prior year total to then multiply it by a growth rate.  (Prior Year * (1 + Growth Rate).PREVIOUS( ) is not working because I do not have Year in the metric, and trying to add it was not working.GrowthRate? is a Boolean that has TRUE starting in January 2026 and all periods forwardOriginalValue is a Number metric that has values monthly from January 2024 and all periods forward What I’m trying to get is something like this:IF(GrowthRate?,  (Prior Year * (1 + Growth Rate), OriginalValue).  I also can’t calculate off the OriginalValue metric because the Growth Rates will compound.  If all years in OriginalValue were $1000 and I am adding 10% Growth I would want to see $1000, $1100, $1210, etc...Unfortunately my 2025 occasionally has some 0 seasonality that is throwing off other metrics after this one.   Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2025 1000 1000 0 0 0 1000 1000 1000 1000 1000 1000 1000 2026 =900

1164
Nathan
Employee
S
Newly Minted Pigmenteer
Shane CrinesNewly Minted Pigmenteer
asked in Questions & Conversations
Pigment Rounding Down for Certain Numbers

Has anyone ever noticed Pigment will occasionally round down for certain numbers when using percentages? I was using a fixed 2.95% and it showed up as 2.9% when using one decimal. I ran a test below starting with 0.95% + 1% and noticed other instances of this happening like 5.95% → 5.9%.    

1024
Benoit
Community Manager
argo
Just Arrived
argoJust Arrived
asked in Questions & Conversations
Adding columns to an income statement

I’m trying to add 2027 to all of my financial statements, which currently end at 2026. These months exist as a dimension in the datahub.My supporting apps (revenue, expenses, balance sheet forecast, cash flow forecast) all include 2027 by month.This is probably simple. Any ideas?

561
Nathan
Employee
Neo
Newly Minted Pigmenteer
NeoNewly Minted Pigmenteer
asked in Questions & Conversations
How do I limit date options in input cells with date as data type

Hi Community!!! I just accidentally input 1-Jan-1925 instead of 2025 in a cell with date as data type, and now I couldn’t find that record because 2025 is set in page selector . How can I restrict users from adding dates that aren't possible? Snip below is what I am currently seeing in Pigment which shows a lot of old dates that won’t be used. Thank you!Neo 

591
CDALMAY
T
Newly Minted Pigmenteer
TELIT002Newly Minted Pigmenteer
asked in Questions & Conversations
How to set up level-based hierarchies (e.g. cost center, profit center, products)

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?

1653
oliverlee
Seasoned Pigmenteer
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Partner Solution Consultant Certified Badge

Which learning path/certification is to be completed in order to get this badge: Partner Solution Consultant Certified ?

1471
J
Employee
S
SuzzyOccasional Observer
asked in Questions & Conversations
What is the formula to get average of specific month

Hi Team - I’d like to seek your help on how to do the formula for specific months?Previously I’m using Moving Average, however I realized that it’s better to lock the average to specific months. For context this is my current formula → MovingAverage(Actuals,3) - so that it will get the average of the latest 3mos. What I want now is to just get the average of the months of July, Aug, Sep.In addition, the metric in which I will be using the formula allows manual input override. Once I update the formula of the average, will it override the manual input?Thank you in advance for your help!

1563
S
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
Find the text referencing the txn lsit

Hi! Can you please help creating a formula for below?  In <BT: Interchange + Pass Through Transactions> transaction list  &  <Card Type> property dimension “does_not_apply” only, review <Description> property text and populate the <Card Type> dimension in <Text> property if the <Description> property contains the text listed in the <BT: does_not_apply Remap> transaction list? Thank you!

992
Y
Newly Minted Pigmenteer
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Extract time from Text format

Example:“10/17/2024 14:00:00 -07:00” is a text format; Date with time.I need to extract time from this text format , how to do in Pigment?Also, does it mean 2pm 7mins?Convert text to date&time format

892
Benoit
Community Manager
V
Newly Minted Pigmenteer
VicoNewly Minted Pigmenteer
asked in Questions & Conversations
Import SFTP - Most recent file is not working

Hi! Can anyone help me with the correct format for this import? Last time that I updated the file was on Sept 25th 2024. I’ve checked this document and seems to be ok,so, not sure what may be going on:  

661
W
Employee
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
Using dec 24 FTE as a reference value for the forecasted months

Hello,In the below metric I want to use Dec 24 FTE (128.65) as a reference value for the forecasted months based on the metrics CALC_FTE.I used [Select:Month-1] but it’s only working for the first projected month which is jan 25  but not for the forecasted months.For example in february and other forecasted months we should have 128.65+24Thanks for your help  

453
CDALMAY
E
Just Arrived
emilialuJust Arrived
asked in Questions & Conversations
Adding a new Version

Hello, There was a change in the FTE number forecast for the months to go. I would like to add a new version to Pigment to reflect that. Could you please help me by explaining how I can do that? Thank you.

811
Nathan
Employee
N
Newly Minted Pigmenteer
Noella ThierryNewly Minted Pigmenteer
asked in Questions & Conversations
Transfer value from one quarter to another without values moving when changing switchover dates

Hello!I want to transfer values from one quarter to another, based on certain conditions written by IF[...] and I am using filter and select as shown below:[filter: 'Actuals & Dimensions (Datahub)'::Quarter.'Quarter -1'][Select: 'Actuals & Dimensions (Datahub)'::Quarter-1])))However, when switching the switchover date, the values that I moved from Q to Q+1 will not be in Q+1 anymore. do you have an idea of a better clean way to code this?Thank you very much :))

595
Nathan
Employee
A
Seasoned Pigmenteer
A_GarneriSeasoned Pigmenteer
asked in Questions & Conversations
How "RANK" (Sequential), ranks?

 Hello Pigment,I would like to ask for your help regarding the RANK function, as I don’t fully understand the logic behind the ordering of its rank.Initially, I thought it considered the order of the list used as a dimension; that is, if my first 5 values to rank are equal, my rank 1 would be the first item in the list. However, this doesn’t always work that way. Here’s an example: Ideally, I want to create something like "ISFIRSTOCCURRENCE" that allows me to identify the first value created (like in Anaplan). My initial approach was essentially that: if my rank value is 1, then that is my first occurrence. However, I can’t achieve this correctly.What is the logic behind using "Sequential" as argument then? How does it behave? Or how does it find the values to rank? Do they rely on the ID behind the list items when the ranking attributes are the same?I found a post where they created a list of values to rank and used BY FIRSTOCCURRENCE, but that would require creating the list every ti

1633
Gabriel Amaro da Luz
Employee
Louie
LouieKeen Learner
asked in Questions & Conversations
Previous Function with Multiplication

Hi Pigmenters,Any suggestions on how to write a more elegant formula to achieve the results shown in the Excel please.Here s the current solution: ifblank(ifblank(Metric, 1)*previous(Month), Metric) Thanks, Louie 

933
Louie
A
Newly Minted Pigmenteer
Antonin GRNewly Minted Pigmenteer
asked in Questions & Conversations
Create a block through an API

Hello,  I am exploring API’s capabilities in Pigment and by now I found that API can be used to : Import / Export data  Manage users in the case we use SCIM  Monitor application Audit logsI did not find any documentation about managing (create, modify, delete) blocks. For example, I would like to create a metric. Is there a way to do it through an API ?  Thanks a lot for your answer, Antonin

512
A
Newly Minted Pigmenteer
W
Weining BenKeen Learner
asked in Questions & Conversations
Count number of occurrences and mark the last occurrence

Hello,I currently have the following table, in the first column I fill in tickets manually.And now I have two needs:I hope to count the number of corresponding Tickets through the second column. I hope to mark the last ticket in sequence.I tried using the Rank function, but couldn't achieve these two needs accurately. Can you give me some suggestions?Thank you in advance!!

3165
A
Seasoned Pigmenteer
R
Just Arrived
RohitDivate_GustoJust Arrived
posted in Questions & Conversations
Looking to make a SWITCH?? Hiring a Full Time Pigment Solution Architect in NYC for Gusto

https://boards.greenhouse.io/gusto/jobs/6286911We have been customers for 1+ year and have already done the implementation. We love the tool a lot! We have a lot of net new builds and enhancements we want to do, so plenty of interesting problems to tackle. Gusto is $10b private SaaS company on the path to IPO, so a very exciting place to be and this role will directly report to me in Finance.Additional details:NYC based → we have most of the team there, so would like someone 3 days in office. We have relocation benefits. Level → flexible based on experience Visa Sponsorships → TBD, if we find a great candidate, we might sponsorApply on the link above AND directly email me at rohit.divate@gusto.com Thanks!

640
R
Just Arrived

Badge winners

  • Read and Interpret Formulas Certified
    kimlopo23has earned the badge Read and Interpret Formulas Certified
  • Innovator
    Naomi Vriendhas earned the badge Innovator
  • Pigment Modeling Fundamentals Certified
    Aaron Ghas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Modeling Fundamentals Certified
    r.karsanhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Modeling Fundamentals Certified
    Seney SEANhas earned the badge Pigment Modeling Fundamentals Certified
Show all badges
Terms & ConditionsCookie settings