IF name1 = name2

[Anonymous]

Hi,

I am trying to use if condition in traffic light gauge expression

*After selecting transaction number, which is link*

=IF(  [Owner Name] = [Seller Name], 0,1)

*Both variables are from different tab and excel data. I like to load different excel into different tab for easier fault/error finding.

My traffic light indicator is set as indicate value, segment 1 lower bound 0, segment 2 low bound 0.5.

Please help me

btw, am I able to set the traffic light to a single colour (grey) when nothing is selected?

Message was edited by: Jia Sheng Loh Add In Examples.

[Anonymous]

Try this

[Anonymous]

Thanks for the quick reply!

However this I not what I am looking for

I am test if the buyer name is the same as Supplier Name base on supplier code. However there are many supplier name under a same supplier code. Thus, when trying to refer my buyer name to supplier code, it does not light up, On my attachment, with the excel data, Transaction 2 lighted up because there is only one name under that supplier code.

I think is call comparing multiple list to a single list?

[nagarjuna_kotha]

Could you share sample data ?

-Nagarjun

[Anonymous]

My post with sample data is currently being moderated. Sry about that.

[Anonymous]

HI, anyone have a solution?

[Anil_Babu_Samineni]

Your Expression seems ok to me where do you getting stucked

=Evaluate(Alt(IF([Owner Name] = [Seller Name], 0,1), Null()))

[Anonymous]

I want to compare a single name (buyer Name) with multiple name (Owner Name) with the same supplier code and my expression is written in the gauge and not back-end script.

For example

OwnerName,Supplier Code

Peter           ,1111

James         , 1111

BuyerName, Supplier Code

James         , 1111

I am stuck at it should return me 1 as BuyerName 'James' match with OwnerName under same supplier code. But my if else statement in the gauge work in the way that it check the first name of OwnerName and return me a 0 instead.

I am unable to use evaluate because my OwnerName is different excel and tab from BuyerName.

[Anonymous]

HI,

Has anyone able to figure this out? Really appreciate it.