Hi,

For any number of reasons you might want a value not to be taken into account in the calculation. This can be accomplished by updating the item using the API, but this can be not flexible enough in some situation, because wrong values might be used in the calculation before the formula is updated.

I would like to have condition possibility in a calculated item. This allows us to ignore values of a certain item when the value of another item has a certain value (eg: state == "maintenance" or value > 100000).