Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good Day,
I'm trying to create an expression to display a Zip Code as #####-#### if it is 9 digits or as ##### if it is 5 digits.
Can anyone point me in the right direction?
Solved! Go to Solution.
Figured it out:
=IIf(Len(Fields!Zip.Value) = 5, Fields!Zip.Value, Left(Fields!Zip.Value, 5) &"-" & Right(Fields!Zip.Value, 4))
Figured it out:
=IIf(Len(Fields!Zip.Value) = 5, Fields!Zip.Value, Left(Fields!Zip.Value, 5) &"-" & Right(Fields!Zip.Value, 4))