Ignore boolean flagged items/periods when using the AVERAGE function
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.
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.
This will eliminate the need to create additional line items to facilitate the exclusion of items in the calculation of average values.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.