Ignore Value Parameter for MIN Function
When using a minimum function, it would be ideal if we could exclude specific values, or a list of values, to avoid returning zeros or another value.
For the aggregation function x[MIN:y] you may want to exclude zeros from the formula. Currently the workaround is to use a large number in place of zeros, eg: "IF x = 0 then 9999999999999999 else x" and then use the summary method Min. Added an additional exlude parameter would eliminate the need for this workaround.
Another alternative I've seen is using a subset on the list, but this isn't ideal when you think about values intersecting another dimension, eg: time. If an item had a value one month and not the next, you would have to rapidly rebuild the subset, or you would still return zeros.
For the formula, it is simply MIN(item 1, item 2, item n), but adding an exclude could look something like: MIN( (item 1, item 2, item n), (exclude value 1, exclude value n) ) or something similar.
I've seen a number of people ask about this, but I haven't seen anyone post this as a recommendation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.