Custom Table Calculations

Use a Helper Function to Calculate Comparisons

At the end of this lesson, you will be able to:

• Use the calculation editor to write table calculations.
• Use the table calculation editor to set scope and direction.
• Describe what these helper functions do: FIRST(), LAST(), INDEX().
• Describe what a LOOKUP() function does.
• Write table calculations that use helper functions.