VC Y/N expression calculation issue

[AK_SMU]

Hi,

I have a virtual column [ReqTimeout] with a simple expression to evaluate a condition (yes/no). It is one of several conditions for status evaluation. When I test this expression, the result evaluates correctly, but if I evaluate the data of the entire table, the result is always FALSE, even when it should be TRUE.

Here is the test result:

Here is detail of calculation:

Here is full row calculation with different result:

Can someone please advise me where I am doing wrong? It is time-consuming to find the problem, especially when the behavior of the application does not match the result of the expression test. How is it possible that the expression test calculates a different result than the application? This leads to a great loss of time and makes it difficult to discover the problem.

Thank you

[Marc_Dillon · Accepted solution]

Remove all instances of "[_THISROW]." from your expression, they are unnecessary here.

I assume the "+3" should mean add 3 days? Change it to "+ 072:00:00"

Instead of testing things equal to TRUE or FALSE, you can use:

[column] in place of [column]=TRUE

NOT( [column] ) in place of [column]=FALSE

[AK_SMU]

Hi Marc

The calculation is now correct after the adjustment you suggested. 
Seeing that you have Y/N's mysteries screwed up.

You saved me a lot of time. 
Thank you for your help.