Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have 2 columns.
Min_Diff Min_Target
36 15
12 15
38 15
06 15
The formula in the Expression is
=if(Minutes_Difference <= Target_Min, 'Pass', 'Fail')
When i compare these 2 columns, the Result column is
Min_Diff Min_Target Result
36 15 Pass
12 15 Pass
38 15 Pass
06 15 Pass
Expected Result is
Min_Diff Min_Target Result
36 15 Fail
12 15 Pass
38 15 Fail
06 15 Pass
What is wrong with my expression? Thanks.
Are the two fields in the same table?
What does your data model look like?
You have Min_Diff in your example, but Minutes_Difference in your expression.
Are Minutes_Difference and Min_Target numeric or strings?
Can you post a sample qvw showing the problem?
Hello m w,
My apologies. It should be
=if(Min_Diff <= Min_Target, 'Pass', 'Fail')
They are both numeric.
Thank you.
Well you answered one of my questions.
If these fields are both in the same table, you can create a new Pass_Fail field in script:
=if(Min_Diff <= Min_Target, 'Pass', 'Fail') as Pass_Fail
If they aren't in the same table, What does your data model look like?
Can you post a sample qvw showing the problem?