Message based on value

XpandedReports.com
Overview
Getting Started
FAQ
Solutions
Excel Comparison
- Formula comparison
Reports
Computed Columns
- Insert a computed column
- Formulas
- Tips & Tricks
  - Avoid divide by zero
  - Combining data
  - Get first character
  - Get last character
  - Split text columns
  - Abbreviate
  - Message based on value
  - Days since Txn date
Known issues
Sitemap
Recent site activity

Join Our Discussion

Recent site activity

Memorized Reports
edited by Bonnie Nagayama
attachment from Bonnie Nagayama
Percentage Display
edited by Bonnie Nagayama
Excel Comparison
edited by Bonnie Nagayama
Known issues
edited by Bonnie Nagayama
Excel Comparison
edited by Bonnie Nagayama
View All

Computed Columns‎ > ‎Tips and Tricks‎ > ‎

Display a message in a new column based on value in another column

Example
Display 'Balance Issue' text when [Total Balance] is greater than 500

IF([Total Balance]>500.00, "Balance Issue", "")

Note: Need to have quotes for the text type output.

	Search this site

Join Our Discussion

Recent site activity

Message based on value

Comments