on 09-14-2011 2:47 PM
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
Hi,
Try below.
=If(NOT IsNull([X])) Then "X" ElseIf( NOT IsNull([Y])) Then "Y" Else "Z")
Cheers,
Suresh Babu Aluri.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The formula will be like this -
=if(IsNull([X])) then if(IsNull([Y])) then [Z] else [Y] else [X]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.