- - Search the Knowledge Base
Academy
Product Roadmap
Events
Groups

Community
Explore the Community

Explore the Community

Connect with other users, discuss how you're using Pigment, and get inspired

420 Topics

Recently active

Most replies Most views Newest first

KevinNew Pigmenteer

asked in Questions & Conversations

How to replicate the MAXIF Excel function

I have a metric that has two dimensions that have pasted values from another source. What I would like to do is return the last month that there is a value > 0 for a specific row in the metric. In Excel terms, this would be done with a MAXIF function where I would return the max month with the condition that “Net Installs” is > 0. From the screenshot below I want to return the month dimension value of Dec 24Can this be accomplished using just the BY modifier and the MAX aggregation method? Any insights are very much appreciated. Thank you in advance.

BenjiCommunity Manager

published in Job Board

The FP&A Jobs Report #50 (Criteo, Kraft Heinz, CoachHub...)

For all the new joiners, a quick reminder of what you get with this newsletter:👉🏾 Around 10 fresh job offers👉🏻 From top companies worldwide👉 Every weekExecutive Positions [SOFTWARE] FP&A Director,📍Remote, FR Cint is a global software leader in digital insights gathering and has the world’s largest consumer network for digital market research, made up of over 155 million engaged respondents across more than 130 countries. [MANUFACTURING] FP&A Director,📍Franklin, US Mars is a unified force of 140,000+ Associates and the world’s leading manufacturer of chocolate, chewing gum, mints, and fruity confections. [MANUFACTURING] FP&A Director,📍Boston, US By delivering ultra-high performance and energy efficiency, Lightmatter’s compute engine will power rapid advancements in AI while lowering its environmental footprint. Hiring? Submit a job!Other Positions [FINANCIAL SERVICES] Strategic Finance Lead,📍London, UK

Cedric LJNew Pigmenteer

asked in Questions & Conversations

Sum of last 12 months before the switchover month

Hello, i would like to do the sum or the average of last 12 months before the switchover month. Thanks for your help

Kamil SobczakNew Pigmenteer

asked in Questions & Conversations

Aggregation from Month to Quarter > Seasonality in quarter assumption > Distribution back to Month

Hey team, I have an issue to chose the proper modifiers in one of the metric blocks. I have a quota values by month by sales rep and wanted to sum these values into the quarters as a first step. So I’m writing a formula= Metric block with quotas by month [by sum: Month.Quarter]Next step is to use in quarter seasonality which is by Month, see the screenshot below. Total for a quarter is 100%. What’s the syntax to spread quarterly quota value to months ( I was testing add constant but it didn’t work) and then use the in quarter seasonality?

YaejisNew Pigmenteer

asked in Questions & Conversations

Color formatting

Hi! Is there a way I can change the color setting such that Unbilled and Billed dimensions are in different colors? Thanks in advance!!

KevinNew Pigmenteer

asked in Questions & Conversations

Creating an Identity Matrix

I have a dimension that is a number (30 Day Cohort). I think I will need an identity matrix for some calculations later in my model. Is it possible to create a metric that has the 30 Day Cohort x 30 Day Cohort? Here is a simple example of what it would theoretically look like.I have tried playing around with the Value function to convert to numbers and do some sort of comparison to the dimension but it doesn’t return what I would like:IF(VALUE('30 Day Cohort'.Name)<VALUE('30 Day Cohort'.Name),0,1)[BY SUM: '30 Day Cohort']Any ideas or things to try would be much appreciated. At the end of the day, the 1s in the matrix will eventually be values calculated from other metrics but I think I need this matrix to do those calculations. But then again I may not given Pigment’s various functions and how it handles dimensions. So any and all ideas are welcomed :) Thank you in advance!

MohanNew Pigmenteer

asked in Questions & Conversations

Slicer Buttons

currently the user needs to expand the filter selection and select the specific filter criteria. Was wondering if there is any action buttons similar to “SLICERS” in Excel ?

YaejisNew Pigmenteer

asked in Questions & Conversations

NETWORKDAYS formula

Hello, Can you please help me creating a formula to show net working days for each month?The excel formula will be like this: So far, I created a dimension I referenced the article here but could not really understand what I should do to get list of working days for each month. Thank you!

keerthanarameshNew Pigmenteer

asked in Questions & Conversations

Multiple Break down levels

Hi,What’s the criteria to have a another level of breakdown?I was able to have two levels of break down for one of the metric but for the boxed one “R&D SAAS Total” another level of break down doesn’t show up even though the dimensions are all different for each level that I wanted to select. Can anyone share what is the rule/condition to be followed for such multiple level of break down in a table?Thank you!

NachoNew Pigmenteer

asked in Questions & Conversations

Comparison of different scenarios

We’ve created two scenarios for the BP on 24: Target and BudgetThese two scenarios are items belonging to the dimension “Version”.In the attached table, we want to add two new comparative columns, one being "Target bp 24/FY23" and the other "Budget bp 24/FY23". However, it does not allow us to add this calculated item because we cannot compare different dimensions (version and year).How can we do this comparison? it is crucial to be able to compare as many scenarios as we want with the previous year's figures

Eva LacauNew Pigmenteer

asked in Questions & Conversations

Equivalent of vlookup between text format

Hello, can you please help me with this formula ?I would like to do a formula similar to vlookup between Unique item values (text format) of two transaction lists (check if a transaction list contains (or not) the Unique item values of the other transaction list → if Unique ID of TL1 is in TL2 then yes, otherwise no) Is it possible to use vlookup equivalent between text format values, or do I have to create a dimension ? Thanks in advance!

BenjiCommunity Manager

published in Job Board

The FP&A Jobs Report #49 (Ankorstore, Crocs, Wolt, Uberall...)

For all the new joiners, a quick reminder of what you get with this newsletter:👉🏾 Around 10 fresh job offers👉🏻 From top companies worldwide👉 Every weekExecutive Positions [MANUFACTURING] VP of FP&A ,📍Atlanta, US "This role will also provide strategic financial analysis, recommendations and guidance to the Executive Leadership Team on a wide variety of business topics and initiatives. This is a critical position on the Dematic Finance Leadership Team and will lead a group of talented executives spanning all areas of FP&A and Finance Business Partnership." [SOFTWARE] Global VP of FP&A , 📍San Francisco, US "This is a great opportunity to lead and be a part of a high-impact team in a high-growth, publicly traded, subscription software company approaching $2B in revenue. We provide analysis to support strategic decisions, conduct financial reviews of various business areas and manage financial processes such as planning, forecasting, reporting

JoseEnthusiastic Pigmenteer

asked in Questions & Conversations

Getting the seasonality for FORECAST_ETS function

Dears,I have the historic sales per month, and we have strong seasonality, but also and upward trend. I would like to use the FORECAST_ETS function, however, I don’t understand how to get the value of seasonality. For example I know every July and August we have a drop and then it gets higher on September. In this case the seasonality would be 12? If I want something more exact can I use Python and then get the equation and plug in pigment? For calculating a better seasonality number, alpha, beta and gamma, is there a way to get those numbers in Pigment, or I need to have another application, such as Python or R? Thanks in advance! Jose

AhmedBNew Pigmenteer

asked in Questions & Conversations

Measuring the size of an application

Hello here!I hope that you are well.Please, is there a way to evaluate the size of an application (like Mb for excel) or the number of calculations made in a Metrics? Sometimes, the calculations take time and I would like to know from where I can remove complexity/heaviness. Many thanks

mmusabEnthusiastic Pigmenteer

asked in Questions & Conversations

IRR Issues

Hi Team I need to compute cell by cell XIRR . So for example, first IRR will be calculated from FY21 to FY 22, FY21 to FY 23 . them FY21 to FY24 and goes on and on. Is there a way to achieve this? So its an expanding calc starting with FY21 and keeps on expanding by brining in additional year. ThanksMusab

BenjiCommunity Manager

published in Job Board

The FP&A Jobs Report #48 (Amazon, Multiverse, Farfetch...)

For all the new joiners, a quick reminder of what you get with this newsletter:👉🏾 Around 10 fresh job offers👉🏻 From top companies worldwide👉 Every weekExecutive Positions [RETAIL] FP&A Director,📍Plano, US "This critical position will have responsibility for the development and implementation of an enterprise level long-term value creation model, maintain and drive adherence to a corporate financial planning calendar, and provide advanced analytical and strategic support for internal and BoD meetings and communications." [SOFTWARE] Head of FP&A ,📍Luxembourg, LU "At Amazon, we're working to be the most customer-centric company on earth. Operations is at the heart of what we do, delivering hundreds of thousands of items each day and fulfilling customer orders from all over the world. The Operations team is seeking a Head of FP&A to guide financial analysis, planning and control for a region in our fast growing Rest-of-the-World Operations Ne

Kamil SobczakNew Pigmenteer

asked in Questions & Conversations

Adding mapping properties in the other app for existing dimension

Hey Team, I have a transaction list with all employees in the Workforce planning and in the same application we created the Employee ID with various properties mapped to this dimension like country, department etc. I would say classic Employee ID dimension block with a mapping. Now we have a need to add additional dimension property at the Employee Id level for a respective department which can be added manually employee by employee by the other team who makes the allocation of sales forces in the other application i.e. it’s not a Workforce app. What type of block we should create to have a kind of a table where we have a list of employees and then column with the list of properties for the allocation?PS. We don’t want to do it at the transaction list level due to security and also this infotramtion will never be available in our HR system to import it. Thanks!

YaejisNew Pigmenteer

asked in Questions & Conversations

Split text

Hi Pigment team! Is there a formula to look for the names dimension name in the Memo, and populate the EE dimension in the new property? Thanks in advance!!

BenjiCommunity Manager

published in Announcements

Pigment Recognized in 2023 Gartner Cool Vendors in Capital Investment Management Software Report! ✨

We’re pleased to announce that Pigment has been recognized in the 2023 Gartner® Cool Vendors™ in Capital Investment Management Software report. According to Gartner:“FP&A software tools often require customization to meet the life cycle of capabilities for capital investments, creating a market opportunity for emerging players. This research introduces FP&A leaders to emerging solutions with differentiated capabilities to digitalize capital investments.” Cool Vendors in Capital Investment Management Software report, 10 August 2023, Michelle Carlsen and Vaughan Archer. Read the full report here! DisclaimerGartner is a registered trademark and service mark and Cool Vendors is a registered trademark of Gartner, Inc. and/or its affiliates in the U.S. and internationally and are used herein with permission. All rights reserved. The GARTNER COOL VENDOR badge is a trademark and service mark of Gartner, Inc., and/or its affiliates, and is used herein with permission. All rights reser

AdamNew Pigmenteer

asked in Questions & Conversations

MOVINGSUM with a variable/metrics as WINDOW SIZE

Hi All, I am using MOVINGSUM which is very helpful but I stumbled on a challenge. I need to use a metrics as WINDOW SIZE rather than a fixed number. Basically the window size need to change dependently on month. I am getting the following error:Error: Function MOVINGSUM requires second argument to be a scalar integer but is defined on Dimensions '00 Hub'::MonthAm I doing sth wrongly? Is there a workaround?Regards,Adam

AabhiiJust Arrived

asked in Questions & Conversations

3 Segment Cashflow Model Circular Reference

Hi, all, I am currently working on a 3 segment cashflow model within pigment. We are currently trying to model the operating cash flow but are stuck with an issue regarding a circular dependency.Within the model, we calculate cash flows (investing, operating and financing). The operating cash flows use management fees to calculate the tax paid, however the management fees are based on total assets which include cash and cash equivalents, which in turn is based on the net cash flow (derived from the combination of investing, operating and financing cash flows). This ends up with a circular reference. Our excel document avoids the circular reference by utilizing the net cash flow from the previous quarter, however doing this in pigment ends with the same circular reference

KevinNew Pigmenteer

asked in Questions & Conversations

Using date functions with a Day dimension as an argument to the function

I have a transaction list with a date as a dimension. This is done so that I can leverage the “delete existing items / limited scope” import functionality as the source data is purged after a 3 year rolling window. Because the date has to be a dimension to do this, I am having difficulty creating the most basic functions on handling the date in my import. It seems that every date function gives me an error that an argument must be of type date. Is there a function I can use to convert the dimension into a date type (i.e., a nested function) so I can use the date functions? I realize I could just change the field in the transaction list to date but I really want to leverage the limited scope functionality. Any insights would be much appreciated. Kevin

KhadijaEnthusiastic Pigmenteer

asked in Questions & Conversations

Pigment sheet view XLOOKUP from another sheet

Dear community, I hope you are all well.Concerning the new pigment update of sheet view.How is it possible to do an XLOOKUP from another sheet? Thank you

Weining BenNew Pigmenteer

asked in Questions & Conversations

How to count the number of employees in different months based on the start and end times

I currently have an Employee Dimension, consisting of four columns:Employee ID | Office | Contract Start Date | Contract End DateI would like to use this to calculate the number of employees in each month, grouped by different offices, as shown in the following figure. The pseudocode would be something like: Count(Employee.EmployeeID, Date.Month > Employee.ContractStartDate && Date.Month < Employee.ContractEndDate)Do you know how to implement this calculation?Thank you in advance!

mmusabEnthusiastic Pigmenteer

asked in Questions & Conversations

Importing Sheet View Calcs into a metric

Hi Everyone Is there a way to bring in sheet’s view calculations that we do based on existing metrics and use them in to create a metric? ThanksMusab

1
2
3
4
...
17

Page 1 / 17

Badge winners

Thierryhas earned the badge Pigment Modeling Fundamentals Certified
mdjuihas earned the badge Pigment Modeling Fundamentals Certified
Sorin Nicolaehas earned the badge Pigment Modeling Fundamentals Certified
Liang Xuanhas earned the badge Pigment Modeling Fundamentals Certified
Nathan Houguethas earned the badge Pigment Modeling Fundamentals Certified

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Single Sign-On Need help?

Log in with your Pigment account

Log into the Pigment Community

Single Sign-On Need help?

Log in with your Pigment account

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK