showing if a result is outside a tolerance parameter

[TAP936]

Hi,

I have a table that includes a Result and a High and Low tolerance that the result can sit within without a flag.

Can any one please help me with how I can show if the result is outside of the tolerance parameter?

thank you

[amitchandak · Accepted solution]

@TAP936 , A column like this

if([result] <= [T2_LO] && [result] >= [T2_HI],1,0)

Or measure , where result, T2_LO, T2_HI are measures

if([result] <= [T2_LO] && [result] >= [T2_HI],1,0)

[TAP936]

Thank you so much 😀