Astera Data Stack
⌘Ctrlk
Astera Data Stack
  • Welcome to Astera Data Stack Documentation
    • Upgrading from Astera 5.1 to 6.0
    • Introduction to Astera 6 Webinar Video
    • Introducing Dataflows
    • Dataflow Examples
    • Parameterizing Dataflows
    • Sources
    • Transformations
    • Destinations
    • Maps
    • Data Logging and Profiling
    • Database Write Strategies
    • Adding Workflow Tasks
    • Creating Workflows
    • Customizing Workflows With Parameters
    • Using Workflow Designer
    • Using Subflows in Astera
    • Report Model Tutorial
    • Applying an Existing Model to a New Report
    • Using Report Models to Extract Business Information from Printed Documents
    • Introducing Function Transformations
    • Functions Glossary
    • Custom Functions
    • Logical
    • Conversion
    • Math
      • 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)
    • Financial
    • String
    • Date Time
    • Files
    • Date Time With Offset
    • GUID
    • Encoding
    • Regular Expressions
    • TimeSpan
    • Matching
    • Job Scheduling
    • Astera API User Guide
    • Astera Best Practices Dataflows
    • Astera Options
    • Astera Webinar Series
    • MySQL date/time conversion error
    • Report Model Monthly Online Training
    • Server Command Line Utility
    • Shared Actions
    • Shared Connections
    • Working with Data Formats
    • Using the Data Source Browser
    • Using the Query Editor
Powered by GitBook
For the complete documentation index, see llms.txt. This page is also available as Markdown.
  1. Version 6
  2. Functions

Math

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)
PreviousToString (Any data, String format)NextAbs (Double)

© Copyright 2026, Astera Software