Manage Indicators: Calculations by Data Type

Manage Indicators: Calculations by Data Type


This page covers:

Indicator Data Type Calculations

The table below summarizes the Number, Currency, and Percent indicator types calculations for various scenarios.

Indicator Data Type

Number of Geographic Areas

Cumulative?

Disaggregation Level

Calculation using Result records

Across...

Indicator Data Type

Number of Geographic Areas

Cumulative?

Disaggregation Level

Calculation using Result records

Across...

 

 

 

 

Target to Date

Result to Date

Reporting Period(s)

Geographic Area(s)

Disaggregated Result(s)

Number

One

Yes

None

Total Target Value

Total Result Value

One (most recent)

One

One (no disaggregation value)

Cross-Disaggregated by Sex

Total Target Value

Total Result Value

One (most recent)

One

One (no disaggregation value)

Disaggregation Group

Sum of Total Target Value

Sum of Total Result Value

One (most recent)

One

All

Disaggregated by Sex & Group

Sum of Total Target Value

Sum of Total Result Value

One (most recent)

One

All

No

None

Sum of Total Target Value

Sum of Total Result Value

All

One

One (no disaggregation value)

Cross-Disaggregated by Sex

Sum of Total Target Value

Sum of Total Result Value

All

One

One (no disaggregation value)

Disaggregation Group

Sum of Total Target Value

Sum of Total Result Value

All

One

All

Disaggregated by Sex & Group

Sum of Total Target Value

Sum of Total Result Value

All

One

All

Multiple

Yes

None

Sum of Total Target Value

Sum of Total Result Value

One (most recent)

All

One (no disaggregation value)

Cross-Disaggregated by Sex

Sum of Total Target Value

Sum of Total Result Value

One (most recent)

All

One (no disaggregation value)

Disaggregation Group

Sum of Total Target Value

Sum of Total Result Value

One (most recent)

All

All

Disaggregated by Sex & Group

Sum of Total Target Value

Sum of Total Result Value

One (most recent)

All

All

No

None

Sum of Total Target Value

Sum of Total Result Value

All

All

One (no disaggregation value)

Cross-Disaggregated by Sex

Sum of Total Target Value

Sum of Total Result Value

All

All

One (no disaggregation value)

Disaggregation Group

Sum of Total Target Value

Sum of Total Result Value

All

All

All

Disaggregated by Sex & Group

Sum of Total Target Value

Sum of Total Result Value

All

All

All

Currency

One

Yes

None

Total Target Value

Total Result Value

One (most recent)

One

One (no disaggregation value)

Cross-Disaggregated by Sex

Total Target Value

Total Result Value

One (most recent)

One

One (no disaggregation value)

Disaggregation Group

Sum of Total Target Value

Sum of Total Result Value

One (most recent)

One

All

Disaggregated by Sex & Group

Sum of Total Target Value

Sum of Total Result Value

One (most recent)

One

All

No

None

Sum of Total Target Value

Sum of Total Result Value

All

One

One (no disaggregation value)

Cross-Disaggregated by Sex

Sum of Total Target Value

Sum of Total Result Value

All

One

One (no disaggregation value)

Disaggregation Group

Sum of Total Target Value

Sum of Total Result Value

All

One

All

Disaggregated by Sex & Group

Sum of Total Target Value

Sum of Total Result Value

All

One

All

Multiple

Yes

None

Sum of Total Target Value

Sum of Total Result Value

One (most recent)

All

One (no disaggregation value)

Cross-Disaggregated by Sex

Sum of Total Target Value

Sum of Total Result Value

One (most recent)

All

One (no disaggregation value)

Disaggregation Group

Sum of Total Target Value

Sum of Total Result Value

One (most recent)

All

All

Disaggregated by Sex & Group

Sum of Total Target Value

Sum of Total Result Value

One (most recent)

All

All

No

None

Sum of Total Target Value

Sum of Total Result Value

All

All

One (no disaggregation value)

Cross-Disaggregated by Sex

Sum of Total Target Value

Sum of Total Result Value

All

All

One (no disaggregation value)

Disaggregation Group

Sum of Total Target Value

Sum of Total Result Value

All

All

All

Disaggregated by Sex & Group

Sum of Total Target Value

Sum of Total Result Value

All

All

All

Percent

One

Yes

None

Total Target Value

Total Result Value

One (most recent)

One

One (no disaggregation value)

Cross-Disaggregated by Sex

NULL

NULL

N/A

N/A

N/A

Disaggregation Group

NULL

NULL

N/A

N/A

N/A

Disaggregated by Sex & Group

NULL

NULL

N/A

N/A

N/A

No

None

Total Target Value

Total Result Value

One (most recent)

One

One (no disaggregation value)

Cross-Disaggregated by Sex

NULL

NULL

N/A

N/A

N/A

Disaggregation Group

NULL

NULL

N/A

N/A

N/A

Disaggregated by Sex & Group

NULL

NULL

N/A

N/A

N/A

Multiple

Yes

None

No calculation possible for Target to Date and Result to Date fields. The fields will be empty on the Project Indicator record.

Cross-Disaggregated by Sex

Disaggregation Group

Disaggregated by Sex & Group

No

None

Cross-Disaggregated by Sex

Disaggregation Group

Disaggregated by Sex & Group