I am trying to print a number and corresponding formatted number based on a condition of "Y" or "N".I want to see just the number and not any corresponding formatted number when the condition is "N".

 

The formatted number is showing up fine when the condition is "y" but when it is "n" I expect to see just the number and nothing for the formatted number but I don't even see the number. Here is the formula I am using

 

If {Table1.Field1}= "N" then " "

Else if {Table1.Field1} = "Y" then

totext(Left({Table2.Field1},2)) + '-' + totext(Mid({Table2.Field1},3,3)) + '-'
+ totext(Mid({Table2.Field1},6,2)) + '-' + totext(Mid({Table2.Field1},8,4)) + '-'  + totext(Right({Table2.Field1},4))

 

Thanks

Deepa

 

Deepa