community.pigment.com Open in urlscan Pro
2600:9000:214f:f200:10:8bf:5cc0:93a1  Public Scan

Form analysis
2 forms found in the DOM

GET /search/index

<form method="get" action="/search/index" data-bounded-context="Search">
  <div class="searchbox searchbox--large qa-search-area">
    <div class="searchbox__input algolia-search--forum qa-menu-search-input">
      <div class="search-and-filter-wrapper" data-bounded-context="Search"><span>
          <div class="algolia-search-container" aria-expanded="false" aria-owns="downshift-2-menu" role="combobox" aria-haspopup="listbox" aria-labelledby="downshift-2-label">
            <div class="algolia-search-container--empty-input">
              <div class="search-box"><button type="submit" aria-label="Enter" class="search-box__submit" data-toggle="button"><svg aria-hidden="true" width="16" height="16" class="" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg">
                    <path
                      d="M15.5 14H14.71L14.43 13.73C15.41 12.59 16 11.11 16 9.5C16 5.91 13.09 3 9.5 3C5.91 3 3 5.91 3 9.5C3 13.09 5.91 16 9.5 16C11.11 16 12.59 15.41 13.73 14.43L14 14.71V15.5L19 20.49L20.49 19L15.5 14ZM9.5 14C7.01 14 5 11.99 5 9.5C5 7.01 7.01 5 9.5 5C11.99 5 14 7.01 14 9.5C14 11.99 11.99 14 9.5 14Z"
                      fill="currentColor"></path>
                  </svg></button><input aria-label="Search" type="search" placeholder="How can we help?" autocomplete="off" autocorrect="off" autocapitalize="off" data-track-type="click keydown" data-element-name="Search input"
                  data-event-filter="enterKeydownFilter" class="search-box__input" aria-autocomplete="list" id="downshift-2-input"><button type="reset" aria-label="Clear search" class="search-box__reset" data-toggle="button" style="opacity: 0;"><svg
                    aria-hidden="true" width="16" height="16" viewBox="0 0 16 16" fill="none" class="">
                    <path
                      d="M8.00065 1.33334C4.31398 1.33334 1.33398 4.31334 1.33398 8.00001C1.33398 11.6867 4.31398 14.6667 8.00065 14.6667C11.6873 14.6667 14.6673 11.6867 14.6673 8.00001C14.6673 4.31334 11.6873 1.33334 8.00065 1.33334ZM11.334 10.3933L10.394 11.3333L8.00065 8.94001L5.60732 11.3333L4.66732 10.3933L7.06065 8.00001L4.66732 5.60668L5.60732 4.66668L8.00065 7.06001L10.394 4.66668L11.334 5.60668L8.94065 8.00001L11.334 10.3933Z"
                      fill="currentColor"></path>
                  </svg></button></div>
            </div>
          </div>
        </span></div>
    </div>
  </div>
</form>

Name: forgotPassword — POST /member/forgotPassword

<form name="forgotPassword" method="post" action="/member/forgotPassword" class="form js-ajax-form--forgot" id="form--forgot__1122238421" data-mn="ItemView" data-mn-app="frontend">
  <div class="js-notification" data-mn="CompositeView" data-mn-app="frontend">
    <div class="box box__pad is-hidden">
      <ul></ul>
    </div>
  </div>
  <div class="form__row">
    <div class="first">
      <label class="label required" for="forgotPassword_username"> Enter your e-mail address </label>
    </div>
    <div class="second">
      <input type="text" id="forgotPassword_username" name="forgotPassword[username]" required="required">
    </div>
  </div>
  <div class="form-row first">
    <button type="submit" id="forgotPassword_submit" name="forgotPassword[submit]" class="btn btn--cta qa-submit-button"> Send <div class="loader"></div></button>
    <a href="#" class="group__item end js-open-modal qa-forgot-password-overview-link" data-modal="login" data-mn="ItemView" data-mn-app="frontend">Back to overview</a>
  </div>
  <input type="hidden" id="forgotPassword__token" name="forgotPassword[_token]" value="3XdkBnnEk2vwjS2mXRKwaLxbN6B98nknN61aMMwlPsk">
</form>

Text Content

Skip to main content




COOKIE POLICY

We use cookies to enhance and personalize your experience. If you accept you
agree to our full cookie policy. Learn more about our cookies.

Accept cookies Deny all
Cookie settings
×


COOKIE SETTINGS


We use 3 different kinds of cookies. You can choose which cookies you want to
accept. We need basic cookies to make this site work, therefore these are the
minimum you can select. Learn more about our cookies.


Basic
Functional

Normal
Functional + analytics

Complete
Functional + analytics + social media + embedded videos

Accept cookies




 * Community
    * 
    * * Home
      * Recently active topics
      * Unanswered questions
      * Explore the Community
      * Community Welcome Guide5
      * Questions & Conversations650
      * Job Board82
      * Announcements34

 * Knowledge Base
    * 
    * * Search the Knowledge Base
      * Documentation
      * Getting Started22
      * Modeling & Formulas42
      * Functions108
      * Reporting & Data visualization44
      * Pigment AI5
      * Collaborating on Pigment21
      * Security & Permissions36
      * Importing and Exporting Data59
      * Test & Deploy7
      * Become a Pigment Pro
      * Modeling Principles7
      * Modeling Guides43
      * Strategic Resources9
      * Newsletter Archives 21
      * Customer Resources
      * Academy Resources 7

 * Academy
 * Product Roadmap
 * Events
 * Groups



 * 
 * Create topic
 * Login





WELCOME TO THE PIGMENT COMMUNITY!




EXPLORE THE COMMUNITY

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


GET STARTED WITH PIGMENT

Find everything you need to get going


BROWSE DOCUMENTATION

Learn about Pigment features


BECOME A PIGMENT PRO

All the best practices and the guides from the Pigment team


FEATURED ARTICLES

 * Connect Pigment With SAP S/4HANA Public Cloud
 * What is Pigment AI?
 * Introduction to Test & Deploy
 * Set Up a Pigment Workflow
 * Introduction to Access Rights
 * Create a Dependent Dropdown on a List


EXPLORE THE COMMUNITY

 * Recently Active
 * Help Others
 * Categories

V

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

1
434

22 minutes ago
O

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?

0
375

35 minutes ago
D

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: (

0
562

5 days ago
B

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 forward
OriginalValue 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 =9000 * (1 + 10%) /12 =9000 * (1 + 10%) /12 =9000 * (1 +

0
374

5 days ago
S

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%.

0
554

6 days ago
RoryCCommunity Manager
published in Modeling & Formulas
Set up your Calendar

Here’s how to make sure your Calendar is set up for your needs. Why set up the
Calendar Define your Calendar Choose your Time Dimensions Basic configuration of
Actual vs forecast Calendar Dimensions, Metrics and Properties Calendar
Dimension Properties with Editable Formulas Calendar Block substitution Ways to
use the Calendar How to delete the Calendar Learn more Why set up the Calendar
Each Application needs a Calendar definition, so that Pigment knows the start
month of your organization’s financial year and the weekly/monthly/quarterly
business cadence, among other things. The guidance below is to set up the
Calendar for one Application, but your organization can also set up Calendar
once, and share the Blocks created across Applications, by using a Library. See
here for more information on using Pigment’s Library feature. Define your
Calendar First, set up some key definitions for your Calendar: In your
Application, select the three dots at the bottom of the sidebar and the

0
950

7 days ago
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?

0
351

8 days ago
P

P_AgrawalJust Arrived
asked in Questions & Conversations
API Import Set up


I am working on setting up an integration between TeamOhana (headcount platform)
and Pigment, which needs to be connected through an API request. Using this
link, I have been able to set up the API connection and the action button to
trigger the integration but I am unsure of where is the data getting pulled
into? Do I need to set up a transaction list beforehand and then somehow link
API request so the transaction data in Pigment gets updated? Essentially where
is my data going if the API request result shows successful? FYI: It is
Authentication: Bear <token> set up.

0
431

8 days ago
N

NeoJust Arrived
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

0
361

11 days ago
Isabella Leslie-MillerCommunity Manager
published in Announcements
Community Direct Message Incident

Hi everyone, I wanted to reach out regarding an incident that occurred on our
Pigment Community platform today. Unfortunately, a user sent private messages
with inappropriate content to several members of our community. We want to be
very clear: this behaviour is entirely unacceptable and violates our community
guidelines. We immediately banned the user and removed their public posts and
comments. We have deleted these messages and are working with our platform
provider to ensure that this doesn’t happen again. We also want to reassure you
that this incident does not involve any data breach or security threat. This was
solely the action of one individual, limited to community spam, and your data
remains secure. We are deeply sorry about this incident taking place. Our
commitment to fostering a respectful, inclusive, and safe environment remains
strong, and we’re taking additional steps to ensure this space remains a
positive one for all. Thank you for your understanding, and please fee

15
1390

12 days ago
Show more activity
V

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

1
434

22 minutes ago
O

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?

0
375

35 minutes ago
B

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 forward
OriginalValue 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 =9000 * (1 + 10%) /12 =9000 * (1 + 10%) /12 =9000 * (1 +

0
374

5 days ago
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?

0
351

8 days ago
P

P_AgrawalJust Arrived
asked in Questions & Conversations
API Import Set up


I am working on setting up an integration between TeamOhana (headcount platform)
and Pigment, which needs to be connected through an API request. Using this
link, I have been able to set up the API connection and the action button to
trigger the integration but I am unsure of where is the data getting pulled
into? Do I need to set up a transaction list beforehand and then somehow link
API request so the transaction data in Pigment gets updated? Essentially where
is my data going if the API request result shows successful? FYI: It is
Authentication: Bear <token> set up.

0
431

8 days ago
N

NeoJust Arrived
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

0
361

11 days ago
T

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?

0
653

12 days ago
P

pigment_enthusiastSeasoned Pigmenteer
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 ?

0
411
J

12 days ago
V

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:

0
331
W

13 days ago
OlaSeasoned Pigmenteer
asked in Questions & Conversations
Link to a prefiltered board


When you apply a filter to a board you can see that the url is updated to
include the current filter. The problem is just that the url only includes a
GUID. Is there any way to find these guids in Pigment? For example when
filtering on a specific employee in my employee dimension I can see that
[]=df7ce50d-304b-472e-a8e0-f448d960e8de is added to the url, and I would expect
that each employee is related to a unique guid, so question is just how to get
from dimension value to a guid. My use case is that I am having a grid view with
a list of employees. For each employee I would like to link to another board
with details about each employee and I would like this board to automatically be
prefiltered based on which row I clicked on the first board.

1
783

14 days ago
Show more activity


EXPLORE THE COMMUNITY

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


COMMUNITY WELCOME GUIDE

 * 5 topics
 * 8 Replies


QUESTIONS & CONVERSATIONS

 * 650 topics
 * 1765 Replies


JOB BOARD

 * 82 topics
 * 1 Reply


ANNOUNCEMENTS

 * 34 topics
 * 35 Replies



Welcome to the Pigment Community! 🎉




1 year ago



CUSTOMER LEADERBOARD

 * Week
 * All time

1
A

a2pham

10 points

10 points

2
A

ayethipathi

10 points

10 points

3
CamilleMomo

10 points

10 points

4
B

Brian B

10 points

10 points

5
W

Weining Ben

10 points

10 points

6
T

Tomer.A

5 points

5 points

7
O

Olga Vovk

5 points

5 points

8
A

Alina

1 point

1 point

Show full leaderboard
1
CamilleMomo

5649 points

5649 points

2
abhilashsawla

3943 points

3943 points

3
CDALMAY

3102 points

3102 points

4
Sofia Costa

2460 points

2460 points

5
A

Alexandre

2413 points

2413 points

6
R

rschimm

2263 points

2263 points

7
MKohli

1883 points

1883 points

8
Sam Gale

1532 points

1532 points

Show full leaderboard


BADGE WINNERS

 * Ali Wrobleskihas earned the badge Read and Interpret Formulas Certified
 * Nahhas earned the badge Read and Interpret Formulas Certified
 * Sharon Conroyhas earned the badge Read and Interpret Formulas Certified
 * angeliqueparavaloshas earned the badge Pigment Modeling Fundamentals
   Certified
 * srxhas earned the badge Read and Interpret Formulas Certified

Show all badges


EMPLOYEE LEADERBOARD

 * Week
 * All time

1
Sharon Conroy

20 points

20 points

2
Amal B

2 points

2 points

3
KarlW

1 point

1 point

Show full leaderboard
1
Benoit

6510 points

6510 points

2
Pierre

3253 points

3253 points

3
Ben

2486 points

2486 points

4
KarlW

2399 points

2399 points

5
Keiran

2016 points

2016 points

Show full leaderboard



NEED MORE HELP?


CONTACT CUSTOMER SUPPORT

Contact our Support team and we'll be happy to help you get up and running!


CONTACT PARTNER SUPPORT

Contact our Support team and we'll be happy to assist you!


Powered by Gainsight
Terms & ConditionsCookie 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 E-mail address. We'll send you an e-mail with instructions to reset
your password.

Enter your e-mail address

Send

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