community.pigment.com Open in urlscan Pro
13.35.93.30  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__2093491782" 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="q7G2IV9sJo9DPCA1KvbDfp1yJdEnaUdimz6wx31hFhc">
</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 & Conversations652
      * Job Board82
      * Announcements34

 * Knowledge Base
    * 
    * * Search the Knowledge Base
      * Documentation
      * Getting Started22
      * Modeling & Formulas42
      * Functions108
      * Reporting & Data visualization44
      * Pigment AI5
      * Collaborating on Pigment20
      * 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

C

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

0
30
C

3 hours ago
L

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

0
80
L

4 hours ago
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
474

1 day 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
425

1 day 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

6 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
404

6 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
604

8 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
1100

9 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
371

9 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
451

9 days ago
Show more activity
C

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

0
30
C

3 hours ago
L

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

0
80
L

4 hours ago
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
474

1 day 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
404

6 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
371

9 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
451

9 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

13 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
663

13 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
431
J

14 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
341
W

15 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

 * 652 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
agnar

90 points

90 points

2
CamilleMomo

30 points

30 points

3
M

michelf

30 points

30 points

4
CDALMAY

22 points

22 points

5
C

Cedric LJ

20 points

20 points

6
L

Laurence Temam

20 points

20 points

7
C

chris.heredia1

16 points

16 points

8
Vivek4829

13 points

13 points

Show full leaderboard
1
CamilleMomo

5669 points

5669 points

2
abhilashsawla

3943 points

3943 points

3
CDALMAY

3124 points

3124 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
agnar

1558 points

1558 points

Show full leaderboard


BADGE WINNERS

 * Camille P.has earned the badge Pigment Modeling Fundamentals Certified
 * Yoann_Delaruehas earned the badge Read and Interpret Formulas Certified
 * 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

Show all badges


EMPLOYEE LEADERBOARD

 * Week
 * All time

1
benjamin.berger

80 points

80 points

2
Sharon Conroy

20 points

20 points

3
Andrea

15 points

15 points

4
Amal B

12 points

12 points

5
Pierre

11 points

11 points

Show full leaderboard
1
Benoit

6520 points

6520 points

2
Pierre

3264 points

3264 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