Skip to main content

Questions & Conversations

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

  • 757 Topics
  • 2,067 Replies
757 Topics
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
ANYOF function

I have a XYZ input metric of data type: Boolean with dimension: Teams andanother metric ABC of data type: number with dimension Manager.I need to create a metric at Manager level with dimension : Manager and data type: number , to fetch the amount from ABC if any of the teams of a specific manager is True.There is already a mapping between manager and teams in the Teams dim list. I tried this formula, but it gives the value even all the teams of a manager in XYZ metric is false. IF(ANYOF('t. XYZ [Input]'),'m. Amount')

1695
RoryC
Community Manager
T
Newly Minted Pigmenteer
Tom S.Newly Minted Pigmenteer
asked in Questions & Conversations
Conditional Formatting applying to totals, how to not include?

Hi Pigment Community,I’m trying to apply conditional formatting to an entire column in a table but not include the Total line, which already has formatting of its own.  Is this possible?Thanks for your help,Tom S. 

623
sethbradley
R
Newly Minted Pigmenteer
rykasaNewly Minted Pigmenteer
asked in Questions & Conversations
Referencing the same number in a month over time

I have Services Bookings that I need to turn into Services Revenue over a set of months based on % of completion. Each Services Bookings (ex: $100K) relates to a product (Product A) that has a set number of services hours (ex: 300 hours) that amortize over a set of months (ex: month 1=50, month 2=150, month 3=100). To calculate revenue by month, I need to multiply Revenue $ per Hour ($100K/300 hours) by hours in each month. How do I reference the same Revenue $ per Hour in each of the 3 months? As I book deals over time, each month will have different Services Bookings that will impact the Revenue $ per Hour for that Services Booking Month. 

653
Nathan
Employee
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Boolean metric - True, False, Blank

I have a metric with so many IFs conditions,Out of those, there’s one condition which checks the other boolean metric is False Or Is Blank.ISBLANK(Is active?) : I am using this logic, its giving me the cardinality error.If I am replacing it with Is Active <> TRUE, it doesn’t give the error ; but it checks only the values which aren’t true, i.e. False, and doesn’t checks the Blank values.Any suggestions? to resolve this as I need to check both “((Active? = FALSE) OR ISBLANK(Active?))”

1423
CDALMAY
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Formula not working as expected - TEXTLIST

In Pigment, I have tried the below formula for City metric: The source metrics are with dimension: Employees and RoleThe target metric is having dimension: Employees and Month.I’ve tried the above formula, but it’s giving me the same abc value across for employees and for all months.Can anyone assist me with this formula in Pigment IF(ISDEFINED('erCity'.Name[BY TEXTLIST: TIMEDIM('erStart Date',Month)]),'erCity'.Name[BY TEXTLIST: TIMEDIM('erStart Date',Month)],IF(ISDEFINED(PREVIOUS(Month)),PREVIOUS(Month),'erCity'.Name[BY TEXTLIST: TIMEDIM('erPlan Date',Month)])) IF(ISNOTBLANK('Employees by Role'.City[TEXTLIST: 'Employees by Role'.Start Date])THEN 'Employees by Role'.City[TEXTLIST: 'Employees by Role'.Start Date]ELSE IF ISNOTBLANK(PREVIOUS(City)) THEN PREVIOUS(City) ELSE 'Employees by Role'.City[TEXTLIST: 'Employees by Role'.Plan Date]City metric in Anaplan with above formula. 

1005
P
MagnusKnapp
Just Arrived
MagnusKnappJust Arrived
asked in Questions & Conversations
Update a dimension list text property from a transaction list

When we are importing data into a transaction list, and the data contains new dimension list items those are automatically added to the corresponding dimension list. However the new item is only added with the unique ID, and all properties (Name) are blank. Is there a way to get the dimension list name property (text) updated (even for already existing items), similar to when a csv-file is manually imported to a dimension list? Would be really nice to get an answer on this. 

1091
Stef
Employee
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
TEXTLIST with UNIQUE

I have a target metric wherein I need to fetch all the project names assigned to a person within 12 months.E.g. If the same project exists for multiple months in the source metric, in the target metric - it should return only the unique ones.I tried this formula, this is working fine and returning all the projects assigned to each person in all the months.But I want to fetch the unique projects.Source Metric has dimensions: project, role, monthTarget metric has dimensions: Project, role.'Project Assigned'.Name[BY TEXTLIST: 'd. Month'][REMOVE TEXTLIST: 'd. Month'] 

761
G
Budding Pigmenteer
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Metric from another application within same workspace cant be published on the board.

I’m trying to publish a metric xyz which is coming from/created in ABC Application (Library → Sharing (ON) for this metric) in my another application PQR, but this isn’t allowing me to do so.Also, I have used this metric in PQR application in various fornulas and it’s taking up the source metric correctly.But when I’m trying to publish this metric on a board in other app- PQR, then in the dropdown, this metric isn’t showing up.

662
P
C
Newly Minted Pigmenteer
CalvinNewly Minted Pigmenteer
asked in Questions & Conversations
Reverse Column Order in Table View

Is it possible to reverse the column order when displaying data in a table for a dimension such as month?For example, I have 12 columns of data by month and would like to display the table from left to right showing Dec-Jan instead of Jan-Dec.

572
C
Newly Minted Pigmenteer
K
Budding Pigmenteer
keerthanarameshBudding Pigmenteer
asked in Questions & Conversations
IFBLANK function for metrics

Hello,I want a metric to have another dimension which can be mapped based on 2 separate criteria.So I created 2 metrics separately with their respective criteria by using BY modifier to map the dimensions.And finally I wanted to combine them together so I used IFBLANK to use either one way to arrive at the final mapping.But the final metric seems to be duplicating some of the mappings and arrives at incorrect results. My goal is to have the metric values to be mapped to the second criteria only if it was not mapped through the first one.How can I implement this in a metric formula?IFBLANK has been working great for transaction list blank items, what would be the similar alternative to be used for metrics?

1424
Lehtohen
Budding Pigmenteer
K
Budding Pigmenteer
keerthanarameshBudding Pigmenteer
asked in Questions & Conversations
Use BY modifier in a metric and retain both the dimensions

I have a metric with “Vendor”, “Sub Department”, “Entity”, “Expense Type” and “Month” as the dimensions.I want to add another dimension “KPI Group” to this metric based on “Vendor” and if its blank then based on “Expense Type”Vendor and Expense Type dimension has the link to KPI Group in their respective dimension list. So when I use [BY: ‘Vendor’.’KPI Group’] or [BY:’Expense Type’.’KPI Group’] this results in the the Vendor and Expense Type dimension getting converted to KPI Group. Instead I want to populate the respective KPI Group based on Vendor or Expense Type and arrive at a metric that contains all these 3 dimensions (Vendor, Expense Type and KPI Group) along with the remaining Sub Department, Entity and Month.How can I arrive at the above mentioned dimension structure for the metric?

1472
K
Budding Pigmenteer
O
Newly Minted Pigmenteer
Oscar SalazarNewly Minted Pigmenteer
asked in Questions & Conversations
Trying to figure out how to use Exclude and Previous functions

Hi,In the picture below I´m currently using the formula: 'First Time Borrower'[by constant:Month."Jan 24"]*'Retention Curve'My First issue is that the multiplication of “first time borrowers” by “retention curve” in Jan 24 works perfectly, but for Feb 24 I need that the retention curve percentage used for the multiplication, starts with Jan 24 and not Feb 24, I mean the percentage for the formula in Feb 24 should de 100% that belong to Jan 24 and not the  82.76% that belongs to Feb 24. I tried using the “previous” function but it keeps telling me there are errors. My second issue is that I´ve been trying to use the exclude function in orden to have the final view as the picture below:I´m trying tu use Exclude to recreate the blank cells. For intersections Feb 24 and Feb 24 I use the formula:  'First Time Borrower'[by constant:Month."Feb 24"]*'Retention Curve'[EXCLUDE:Month."Jan 24"]But when I try the same formula in the next line (Mar 24) but try to include Feb 24 into the exclude func

982
O
Newly Minted Pigmenteer
N
Newly Minted Pigmenteer
newtopigmentNewly Minted Pigmenteer
asked in Questions & Conversations
Undo action in Pigment?

Is it possible to reverse a change in Pigment ? I deleted a block accidentally and the block was being used somewhere and I did not get any warnings before deleting. Now I have errors. - Is it possible to undo a deletion ?

2222
Thu Mai
J
Newly Minted Pigmenteer
JoannaNewly Minted Pigmenteer
asked in Questions & Conversations
Rounding to nearest ten or hundred

I want to round to the nearest ten or hundred. Example: 223,453 --> 223,450 or 223,500. I tried the round formula but it didn’t work.

832
J
Newly Minted Pigmenteer
O
Newly Minted Pigmenteer
Oscar SalazarNewly Minted Pigmenteer
asked in Questions & Conversations
I´m new to Pigment and need help to set up a formula

I started using Pigment 3 days ago and I´m trying to figure out how to recreate an Excel formula in the platform.The excel formula I have is the following:=INDEX($B$6:$M$6,MATCH($A9,$B$5:$M$5,0))*C$7 Basically my issue lies in he part of fixating the formula to one single cell. the multiplication brings the correct result for the first cell in the Table I created, but the formula replicates to all cells in the row and I haven´t been able to figure out how to fixate the first part of the formula in order for the multiplication to only change cells for the last part of the formula (*C$7).Can anyone share some guidance please?

1383
O
Newly Minted Pigmenteer
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Get rid of colors of a metric of dimension data type in a table

I have a formulated metric of the datatype: Dimension and when using this metric in a table, the values are coming correct but these values are colored (multi) because it’s  a dimension metric . Since this metric is used in multiple tables . Is there any way by which I can get rid of the colors of this metric in a specific table?

1135
CDALMAY
Louie
LouieKeen Learner
asked in Questions & Conversations
Dimension lookup

Appreciate your assistance here.... The left screen is the CVS loaded PnL Acct dimension and the right screen is NetSuite Integration. The Coln dimension 'FP&A Category Override' is a user manual input. Is there a way I may do a 'vlookup' in the new table so that we don't have to manually map it again. 

1562
Nathan
Employee
S
SuzzyOccasional Observer
asked in Questions & Conversations
How to make negative amount zero

Hi Team, I have an existing formula for moving average, however I want to add another condition that if the moving average is negative, then the result should be zero.This is my formula right now:IF(Actual?,MOVINGAVERAGE('Actual',3),PREVIOUS('Month))Can you help me how can I add my new condition in this formula? Thank you!

851
sethbradley
V
Budding Pigmenteer
venitiavBudding Pigmenteer
asked in Questions & Conversations
Interns who are converted to permanent contracts

Hi,Do you have a best practice to recommend on how to manage interns who are converted to permanent contracts (=CDI in France) in Pigment?When a trainee is converted to a permanent contract, he keeps the same ID in Workday, which means that when Workay connects to Pigment, and as we base Pigment with the IDs : Pigment doesn't “see”that he no longer has an end date that he has changed contract type that he has a different salary and Pigment doesn't count him as a headcount. My temporary solution is to change the intern’s ID (so I have 1 ID for the intern and 1 ID for the same guy with a permanent contract) but this is very manual, so I was wondering if you had any advice.Thanks

911
Lehtohen
Budding Pigmenteer
V
Newly Minted Pigmenteer
VikatzenNewly Minted Pigmenteer
asked in Questions & Conversations
SaaS Revenue Model

Hi All, I want to start building a simple saas revenue model in Pigment, with basic assumptions such as type of subscription, cost, number of new customers, churned customers, cohorts, cohorts age, retention rate, etc.Looking for ideas and suggestions from the community of where to start, what kind of recommendations you have, which metrics/dimensions should I use. Any recommendations or examples would be highly appreciated!!  :) 

871
Benoit
Community Manager
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Filtering based on two text properties in dimension list.

In a dimension list, if we have a property of Text format, the only filtering options are:Is Not Contains is not blank is blank does not contain isRequirement: If I have two properties ; both of them are of text format, there should be an option to filter the dimension list based on these two properties i.e. Property 1 != Property 2.I believe, although we can create another property in the dim list for validating this with the above formula, but it would be great if we can have a filter for the same.

501
CDALMAY
S
SuzzyOccasional Observer
asked in Questions & Conversations
Formula for average of specific months

Hi Pigment Community! I’m trying to create a Metric wherein if Actual Months, it will get the Actuals Details, while if Forecast Months (starting January 2025) it will get the average of January to September 2024 Actuals. Then for October to December 2024 it should be zero or blank. What is the best formula for this?For context:January to September 2024 - from my Actuals metrics October to December 2024 - zero January 2025 onwards - average of January to September 2024 I also set up a boolean for the months of 2025This is my initial formula:IF(Actual?, ' Actuals' , (IF('Month.’2025’,…. I should put here the formula for the average, then if it is not 2025 it should be zeroThank you in advance for your help! 

971
Lehtohen
Budding Pigmenteer
S
SuzzyOccasional Observer
asked in Questions & Conversations
Combining Actuals and Forecast with Different Dimension

Hi! I’m currently working on a table where I need to combine my Actuals and Forecast. For context, these are the dimensions available:ActualsVendor GL Account Country Currency MonthForecastVendor Name GL Account Country Currency  Month Project DetailsI’m having an issue because when I combine them, the Project Details dimension is being applied to every Vendor in my Actuals. Is there a way that I can combine them without removing the Project Details? We still want to see it especially if we don’t have an actual vendor yet. Thank you in advance for your help!

861
Lehtohen
Budding Pigmenteer
S
SuzzyOccasional Observer
asked in Questions & Conversations
Combining Actuals and Forecast with Different Dimensions

Hi! I’m currently working on a table where I need to combine my Actuals and Forecast. For context, these are the dimensions available:ActualsVendor GL Account Country Currency MonthForecastVendor Name GL Account Country Currency  Month Project DetailsI’m having an issue because when I combine them, the Project Details dimension is being applied to every Vendor in my Actuals. Is there a way that I can combine them without removing the Project Details? We still want to see it especially if we don’t have an actual vendor yet. Thank you in advance for your help!

925
S
A
Seasoned Pigmenteer
A_GarneriSeasoned Pigmenteer
asked in Questions & Conversations
How to identify duplicated unique items on a Dimension List?

Hello Pigment!We have a board where the end user can create new items using the 'Add List Item' action. If the user creates an already existing name, is there a way to identify which items are duplicated? or even avoid this? The alert in the app only directs me to the list but not to the duplicated itemsRegards 

581
CDALMAY

Badge winners

  • Innovator
    IrenePhas earned the badge Innovator
  • Pigment Modeling Fundamentals Certified
    imene.mbarekhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    Gerahas earned the badge Pigment Like a Pro
  • Pigment Modeling Fundamentals Certified
    Gerahas earned the badge Pigment Modeling Fundamentals Certified
  • Chatterbox
    gablahozhas earned the badge Chatterbox
Show all badges
Terms & ConditionsCookie settings