You can generally only select fields that are available in the view, including standard system fields and your custom Global Questions.

This excludes those calculated in the report or view via another calculated field or sub-query, like the date a certain job status is changed or a step is finished.

 This is useful for counting:

• the number of distinct applications (by ApplicationID)
• the number of distinct jobs (by JobID)
• the number of distinct candidates (by CandidateID)
• i.e. the number of unique answers for any field

1. Click #!

2. Select your field

3. Click ) (because you automatically got an open bracket by choosing #!)

 This is useful for counting:

• peforming the above calculation (Count Distinct) in only selected cases, e.g. application is submitted, gender is female, favourite colour is purple.
• a different way to update or combine answers e.g. display Northern Territory as NT

1. Click Case

2. Click When - you'll then get another pop-up screen.

WHEN

1. Select Field e.g. State 

2. Select Operator e.g. =

3. Type in a value for the field e.g. North Territory

4. Select Add

THEN

5. Type in a value for the answer you want displayed when the above is true

6. Select Add

7. Select Save to return to the formula screen

8. Continue adding more When statements as required, e.g. When State = 'Victoria' Then 'VIC'.

ELSE

9. When you've finished adding When statements, you may choose to add an Else statement to cover any other possible outcomes

END

10. Once done, ensure you add an End to close the Case When argument. You'll get an error if you don't.

• You'll need to enter your argument sequentially.
• If you need to go back a step, or a number of steps, click the Undo button for that section, once for each step taken. Take care when doing so.
• If you need to start a section again, e.g. the entire When section, click Clear. Do this with caution.
• When you have finished your formula, click Validate to check that the formula is complete and not missing any components.