Data Comparission

[Anonymous]

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.

[m_woolf]

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?

[Anonymous]

Hello m w,

My apologies. It should be

=if(Min_Diff <= Min_Target, 'Pass', 'Fail')

They are both numeric.

Thank you.

[m_woolf]

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?