Astera Data Stack
search
Ctrlk
  • Welcome to Astera Data Stack Documentation
  • Release Notes
    • Upgrading Astera 6 to Version 7
    • Release Notes for Astera 7.1
    • What is New in Astera 7.4
    • What’s New in Astera 7.4.1.221
    • What’s New in Astera 7.6
    • Upgrading to Astera 7.6
  • Setting Up
    • System Requirements
    • Installing Astera Data Integrator
    • Setting up Astera Integration Server 7
    • UI Walkthrough - Astera Data Integrator
  • Dataflows
    • Introducing Dataflows
    • Sourceschevron-right
    • Transformationschevron-right
    • Destinationschevron-right
    • Data Logging and Profilingchevron-right
    • Database Write Strategieschevron-right
    • Text Processorschevron-right
  • Workflows
    • Adding Workflow Tasks
    • Creating Workflows
    • Using Workflow Designer
    • Customizing Workflows With Parameters
    • Workflows with a Dynamic Destination Path
    • Resuming and Rerunning Workflows in Astera
  • Subflows
    • Using Subflows
  • Functions
    • Functions Glossary
    • Introducing Function Transformations
    • Custom Functions
    • Logicalchevron-right
    • Conversionchevron-right
    • Mathchevron-right
      • Abs (Double)
      • Abs (Decimal)
      • Ceiling (Real)
      • Ceiling(Decimal)
      • Floor (Decimal)
      • Floor (Real)
      • Max (Decimal)
      • Max (Date)
      • Min (Decimal)
      • Min (Date)
      • Max (Real)
      • Max (Integer)
      • Min (Real)
      • Pow (BaseExponent)
      • Min (Integer)
      • RandomReal (Int)
      • Round (Real)
      • Round (Real Integer)
      • Round (Decimal Integer)
      • Round (Decimal)
    • Financialchevron-right
    • Stringchevron-right
    • Date Timechevron-right
    • Fileschevron-right
    • Date Time With Offsetchevron-right
    • GUIDchevron-right
    • Encodingchevron-right
    • Regular Expressionschevron-right
    • TimeSpanchevron-right
    • Matchingchevron-right
  • Report Model
    • User Guidechevron-right
    • Report Model Interfacechevron-right
    • Use Caseschevron-right
    • Exporting Optionschevron-right
    • Miscellaneouschevron-right
  • Project Management
    • Project Managementchevron-right
    • Job Schedulerchevron-right
  • Web Services
    • Configuring Google Drive API through REST Client in Astera
    • Connecting to Eloqua using Astera REST API
    • POSTing Data Using the REST Client
    • Using the REST Client to Download a Text File
  • Metadata Management
    • Lineage and Impact Analysis
  • Connectors and Providers
    • Setting Up Oracle ODP.Net Connectivity in Astera
    • Running Microsoft Access Database Engine with Astera
    • Oracle Client Tools Setup
    • Oracle Data Load Options
  • Miscellaneous
    • Job Trace Improvements
    • SmartMatch Feature
    • Synonym Dictionary File
    • Using the Data Source Browser in Astera
  • Best Practices
    • Astera Best Practices - Dataflows
    • Cardinality Errors FAQs
    • Overview of Cardinality in Data Modeling
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. Functions

Math

Abs (Double)chevron-rightAbs (Decimal)chevron-rightCeiling (Real)chevron-rightCeiling(Decimal)chevron-rightFloor (Decimal)chevron-rightFloor (Real)chevron-rightMax (Decimal)chevron-rightMax (Date)chevron-rightMin (Decimal)chevron-rightMin (Date)chevron-rightMax (Real)chevron-rightMax (Integer)chevron-rightMin (Real)chevron-rightPow (BaseExponent)chevron-rightMin (Integer)chevron-rightRandomReal (Int)chevron-rightRound (Real)chevron-rightRound (Real Integer)chevron-rightRound (Decimal Integer)chevron-rightRound (Decimal)chevron-right
PreviousToString (Any data, String format)chevron-leftNextAbs (Double)chevron-right

© Copyright 2025, Astera Software