3 Replies Latest reply: Aug 18, 2011 12:16 PM by javortiz

# Field Comparison and true results

Dear colleagues,

I'm trying to create one formula in the script to get the true results for a series

I have in the database

 Product Comparison 1 Comparison 2 results a 1 8 2 a 2 2 2 a 3 3 2 a 4 4 2

I would like to have a formula where the results only show the true value in the series and don't consider the other.

Could anybody help me to define the formula?

Leandro Duarte

• ###### Field Comparison and true results

I'm not completely clear on what you are trying to do, but I think you could try an if statement, leaving off the else part, then supress null values.

• ###### Field Comparison and true results

Hope I got what you want, I think I might have not really understood your issue (an example might help, then):

=if(Comparison1=Comparison2, results)

as expression?

If zero values are suppressed in presentation tab, you will only see rows with Comparison1 equals Comparison2 (if Product, Comparison1 and Comparison2 are dimension, with above expression)

Regards,

Stefan

• ###### Re: Field Comparison and true results

I dont know how yo get the number 2 in field results, but looks like if comparison 2 is >= comparison 1 Then results.

If is that case I think It would be something like this

If(Comparison 2 >= Comparison 1, 2,)      as   Results Flag

then you have created a new field with just numbers 2 and blank spaces,  now you can use this field to make a new field

len(Results Flag)           as  ResultsFlag2

If(ResultsFlag2 =2, 2,Null())         as FinalResults Flag

this new field has just the registres with just the values with number 2.

I hope thats what you are looking for.