cancel
Showing results for 
Search instead for 
Did you mean: 

If function In WebI

Former Member
0 Kudos

Hi,

I have three values in my report X,Y,Z. I have to show X as the main value but when X is null I need to show'Y' if both X,Y are null I need to Show 'Z'..

Could you please help me with Syntax for the same.

Thanks in Advance,

Regards,

N Kishore

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Try below.

=If(NOT IsNull([X])) Then "X" ElseIf( NOT IsNull([Y])) Then "Y" Else "Z")

Cheers,

Suresh Babu Aluri.

Former Member
0 Kudos

Thanks

Answers (3)

Answers (3)

Former Member

Hi,

This formula is for when X,Y,Z are character data type,

Replace ! with < and = with > in below formula

 =If(Length([X])  != 1) Then [X] ElseIf(Length([X])= 1 And Length([Y])  != 1) Then [Y] Else [Z] 

Regards,

Ragoth.C

former_member817653
Participant
0 Kudos

The formula will be like this -


 =if(IsNull([X])) then if(IsNull([Y])) then [Z] else [Y] else [X]

amitrathi239
Active Contributor
0 Kudos

Hi,

Try with below formulas.

if X,Y,Z are the objects then you can try with below one.

=If(IsNull([X])) Then "Y" ElseIf(IsNull([X]) And IsNull([Y])) Then "Z" Else "X")

=if([x])="" then "Y" elseif (([X]="") and ([Y]="")) then "Z" else "X"

Thanks,

Amit