Hola,

Using a Formula Data Reference how does one go about testing if an attribute is excluded?

I need to be able to test if a value is bad or excluded (so just using badval won't work) and produce two different results based on that.

Thoughts?

Cheers,

Calman

Hi Calman,

I found a similar discussion here: Excluded Attribute in Analyses

Currently, it seems that there is no straight forward way to do this and the 'IsExcluded' function is not yet available.

Furthermore, the functions in a Formula DR are much more limited compared to an AF Analysis.

In the short term, I would say that the likelihood of an elegant solution using a Formula DR is very slim.

Is there any particular reason why you prefer to use a Formula DR?If you are open to using an AF Analysis, I feel that there is a possible immediate solution.

During my tests, I noticed the following behaviour:

If the data in your PI Point never assumes the "No Result" digital state, then you could try the following logic:

If 'MyAttribute' = "No Result" Then<insert EXCLUDED logic>Else If BadVal('MyAttribute') Then<insert BAD logic>Else<insert GOOD logic>Just FYI, I also tried using the same strategy with a Formula DR but I couldn't find a way to make it recognize the "No Result" digital state.

Again, this seems to be a limitation with the Formula DR.