Formula Wizard

From DataSelf Knowledge Base
Revision as of 02:05, 20 March 2014 by Cwilson (talk | contribs) (Created page with "{{#breadcrumb: DataSelf ETL}} {{Category:DataSelf ETL}} {{Category:DataSelf ETL Formula Wizard}} Navigation to here: ALT-M == IF & CASE Statements in the Formula Wizard == ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

==== Glossary Entry: ETL ==== Category:DataSelf ETL Formula Wizard

Navigation to here: ALT-M

IF & CASE Statements in the Formula Wizard

Adding Making calculations after an If or Case Statement

You need to add both numeric fields first. Then select (highlight) the first numeric field, and click on the operator (+, -, X, /). The operator will then insert itself after the selected field.

You can put If statements inside a Case statement, but not a Case inside an If.