Calculations

Download Transcript

Timestamps:

  • 0:04: FAQ Resource
  • 0:24: Hardcoded values
  • 0:52: Piping values into equations
  • 1:31: Exponents
  • 2:11: BMI
  • 3:05: Calculations based off other calculated values
  • 4:15: If...then statements
  • 5:36: Nested if...then statements
  • 6:58: Nulls
  • 7:38: Sum options
  • 9:02: Datediff calculations
  • 10:48: Rounding
  • 11:19: Datediffs using "today"
  • 12:28: Data quality rule H