If Else Condition Fails

[rajni_batra]

Hello Guys,

I have a scenario like i Have 2 Fields A and B

if(A<>B, 'Yes','No') but for some IDs both conditions are true but i want to display it as YES only if its falling in No also.

[Or]

I don't follow. Either A <> B, or it isn't. How can both conditions be true? Perhaps you could post some sample data?

[rajni_batra]

Here against One ID there 3 FBC's in Web but 1 FBC in NAV. i have used expression

Booking ID	Web FBC	NAV FBC	=1
			1
NN251683034998	EAP30	EAP30	1
NN251683034998	LE3M	EAP30	1
NN251683034998	SAP14	EAP30	1
NN251683034998	WE4M	EAP30	1

=if([Nav FBC]<>[Web FBC],'FBC','NON FBC')

and OutPut is like below:

Booking ID	Web FBC	NAV FBC	=if([NAV ]<>[Web FBC] and Flag='Both' and Status='E','FBC','NON FBC')	=1
				1
NN251683034998	EAP30	EAP30	NON FBC	1
NN251683034998	LE3M	EAP30	FBC	1
NN251683034998	SAP14	EAP30	FBC	1
NN251683034998	WE4M	EAP30	FBC	1

Hope this will clear my problem

Regards,

rajni

[christian77]

Hi:

You may have double values in some cases. That means, for a value of A, you have 2 values on B, and one accomplishes the equality and the other one does not. The result is null.

Check that out.

[rajni_batra]

Sorry But I couldn't Get you..

[#6]

Hi Rajini,

post sample file with some data.. so, that it will be clear

[Or]

I'm still not really clear - what was the output you expected to see? What is incorrect with the output you posted?

If the idea is to have one line for each booking ID, and "True" if at least one case of Web FBC = NAV FBC exists, you could probably use something like:

If(sum(if([Web FBC] = [NAV FBC],1)>0,'True','False').

Which is to say - first, count the number of cases where Web = NAV and then if that number is greater than 0, show true. This should work in a chart where Booking ID is the dimension and this is an expression. If you need to use it in a dimension, you'd have to use aggr().