Copy and Paste the following formula using your data where necessary.
({Field 1 (REF)}.equals({Field 2 (REF)})) ? {SetBasedonField 3 (REF)} : {SetBasedonField 4 (REF)}Nested IF Statement
Updated Nov 22, 2019
K3 7.0 User Guide
Data Stream
10
- How Do I View My Data In the Data Stream?
- How Do I View Source Data?
- How Do I View Target Data?
- How Do I Hide Columns I See in the Data Stream?
- How Do I Export Data to CSV or to Excel?
- How Do I Generate a Report From Data Streams
- How Do I Distinguish Between Source and Target Data in Filtering?
- How Do I Filter Data In Data Stream?
- How Do I See The State Of a Process in K3 Data Stream?
- How Do I Upload a File For a File Upload Route
Formula Rules
18
- Convert Currency Symbols to Strings
- Trim a Field
- Absolute Value
- Nested IF Statement
- Add/Subtract Time to a Date
- Compare Dates
- Add Months or Dates to Date and Compare
- Replace Parts of a String
- DateTime Manipulation
- Round Decimal Values
- Days Between Two Dates
- Date to String with Formatting
- Cast Decimal to Integer
- Padding a String with Characters
- Parse a String / Extract a Substring
- Hashing Values
- 'Like' Regex Values for Use with When Statements
- Convert EU Currency Value Stored in String to Decimal
Other Resources
-
Knowledge Base
- K3 AWS Setup Guide