In this session, we’ll look at some useful formulae and techniques to help you get more from your reports, including:

  • Using the ‘Queen Formula’ to return and sort data from your reports
  • Working with dates, including calculating working days and using CURDATE() and NOW()
  • Working with blanks and text using formulae such as IS_BLANK, CONCAT and CONCAT_WS
  • Formatting and converting data, including dates, columns and currencies