System Calculations

  • Burst: Used to build a burst report which can either allow distributions, sub-reports accessible as drill-downs, or the ability to return fields from other reports.
  • Conditional: Allows for "If/Then/Else" logic to be used to produce a true or false result.
  • De-Duplicate: Handle redundant information by clearing duplicate records in a column based on how data is grouped.
  • Formula: A method of performing calculations that allows for typing of expressions to calculate new values from existing values.
  • Group Rank: Returns the relative rank of a value within a numeric column.
  • Group Row Index: An index or numbering applied to rows within a group to indicate their position or order.
  • Group Summary: An aggregated result or computation that summarizes the data for a specific group, like a total or average.
  • Hyperlink: A reference or navigation element that allows users to easily jump to a URL with a single click.
  • Mask: Allows a user to determine which data is to be allowed or disallowed based on specific conditions. This calculation is only utilized for Administrators using masking security.
  • Parent Child Hierarchy: Allows you to create a tree level grouping of records when a parent-child relationship exists leveraging two fields.
  • Random Row Index: A random index assigned to each row, often used for random sampling or shuffling data.
  • Range Filter: Allows date range filters to be more easily created with in between ranges or exclusion ranges.
  • Row Index: A unique identifier assigned to each row in a table to indicate position or order.
  • Spacer: An empty or blank column used to create space between columns for better readability, formatting or organization.
  • Security Audit: Security Audit is used by ReportsNow to grab the User ID and Role from the JDE security table, F0092, and create the Security Audit Report Grouping on Identity.
  • Type Converter: A function that changes a column's data from one data type to another, for example, converting a text string to a date type.
  • URL Encoder: A process that converts characters into a format that can be transmitted over the Internet within a URL.
  • XPath Query: Allows for querying data from XML documents using the XPath 1.0 specification.