If statement and logic

Question

Goal: John Joe(12/2) Breakdown: Name: John.Joe (User picker) Birthday: (date&time) If no name is selected then present "N/A" What I have tried: 
 =if(isnull(pv!processvariable.name), "N/A", user(pv!processvariable.name,"firstName")& " " & user(pv!processVriable.name,"lastName") & "(" pv!processVariable.birthday &" )" ) Problem: Issue with If statement

agam · Answer

if(isnull(pv!processvariable.name), "N/A", user(pv!processvariable.name,"firstName")& " " & user(pv! processvariable .name,"lastName") & "(" & pv! processvariable .birthday &" )" ) 
 you seems to be missing an "&" (highlighted in green ) 
 assuming you have a CDT type process variable named: processvariable 
 please correct the typo (corrected in amber)

If statement and logic

Top Replies