Ignore boolean flagged items/periods when using the AVERAGE function
Status:
Your support is needed
Submitted by
m.angeles11
on
11-03-2020
01:39 AM

Description:
As a model builder, I would like to be able to include an additional parameter in the AVERAGE function which is to be used to exclude flagged items or periods from being included in the calculation of average values.
Use Case:
There are numerous circumstances where I have been required to exclude certain items (e.g. zero cells, actual periods) from the calculation of average values.
Benefit:
This will eliminate the need to create additional line items to facilitate the exclusion of items in the calculation of average values.
2 Comments
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.