LogoLogo
Agentnoon.com
  • Agentnoon Help Center
  • Changelog
  • FAQs
  • Agentnoon Help Center
  • Quick Start
    • Video Guides
  • Data Import
    • Data Requirements
    • Attributes Overview
    • Calculated Agentnoon Attributes
    • Data Error Checklist
    • Data Import
    • Partial Data Upload
    • Formulas
  • Access Control
    • Access Groups
    • Advanced Access Controls
    • User Invitations
  • Settings
    • General
    • Fields
    • Compensation Cards
    • Field Duplication
  • Org Chart
    • Org Chart Navigation
  • Hub
    • Chart Navigation
    • Packs
    • Chart Library
  • Forecast
    • Forecast Navigation
  • Scenarios
    • Scenario Creation
    • Single Position Interactions
    • Bulk Position Interactions
  • Advanced Position Interactions
  • Change Tracker
  • Before and After Analysis
  • Scenario Change Log
  • Scenario Comparisons
  • Scenario Refresh
  • Project Creation
  • Talent Selection
  • User Collaboration
  • Undo Actions
  • Scenario Management
  • Scenario Tags
  • Scenario Symbols
  • Approvals
    • Approvals
  • Activity Analysis
    • Activity Analysis
Powered by GitBook

© 2025 Agentnoon Inc. All rights reserved.

On this page
  • Overview
  • Setting up a Custom Formula

Was this helpful?

  1. Data Import

Formulas

Create and apply custom formulas to using your own data fields.

PreviousPartial Data UploadNextAccess Groups

Last updated 1 month ago

Was this helpful?

Overview

Custom formulas in Agentnoon allow you to define new calculated fields using existing attributes in your data - such as compensation - in natural language. These formulas can be used to model costs, estimate severance, apply benchmarks, or capture any custom logic specific to your planning needs. Formulas help turn raw data into actionable metrics.

Setting up a Custom Formula

Creating a formula

  • Navigate to the Attributes and Formulas section and click Add New Formula. Give your formula a clear, recognizable name.

Use variables from your data.

  • From the Available Variables panel, select the data fields you want to include - such as Level, Service_Years, or Full_Compensation.

Write your formula logic

  • Use basic math operations, existing variables, and conditional logic to define your formula. Conditional logic allows you to apply different rules based on specific conditions.

  • You can use supported functions like ifElse, in, min, max, and arithmetic operations.

Example: Suppose you need to calculate severance for employees marked as "RIF" (Reduction in Force). The formula could be structured as: ifElse(in("RIF", [scenarioState]), max(min([Service_Years], 25), ifElse([Level] <= 7, 5, ifElse([Level] <= 12, 7, 19))), 0) * ([Full_Compensation] / 25) This formula considers service years and employee level to determine the severance amount, ensuring precise calculations based on your specific criteria.