How can I ignore Bad/No Data values in a Value Box sum?
I am summing 12 Value Boxes in Axiom. If one of them goes into a Bad/No Data state, the entire sum becomes Bad. Is there a way to ignore Bad values and continue summing only the valid Value Boxes? Any recommended expression or function for this?
2 replies
-
Try the Flbk function described in https://helpcenter.canarylabs.com/t/35yplvp/edit-trends-menu-version-26.
-
Good suggestion ! Unfortunately, the Fallback (Flbk) only works for NoData qualities, not Bad qualities
. We created a work item to include this functionality in the function. We're also exploring the idea of using a "quality" variable within the ValueTransform expression in addition to the "value" variable. In this way, the user could potentially create a conditional statement and check the quality of the value.
Print this page