The secret power of ActivityInfo Formulas - Webinar

Broadcast 13 August 2020

Description

This is a Webinar on using Formulas in ActivityInfo. Formulas allow you to automate calculations in your Forms and do further analysis on Pivot Tables and on Table View. They can also be used in Validation and Relevance rules.

You can download the file below and recreate the Forms with the Formulas. Browse through the the different tabs to view the various Forms or Subforms.

Agenda


 

SETUP

COLLECT

ANALYZE

 

BASIC

Using simple formulas for validation and relevance conditions.

 

Calculate key indicators in tables, and pivot tables 

 

FUNCTIONS

Use functions to work with dates, scoring, and other calculations.

 

Use functions to calculate scores and indicators from dates.

 

SUBFORMS

Include subforms in formulas for relevance rules

 

Calculate indicators and scores from subforms.

 

REFERENCE

Include referenced forms in relevance and validation rules

 

Use reference data to calculate impact indicators.