Formula Property Definition PLEASE HELP

[douglas.167342]

I am trying to get a formula to generate a room Number and can get it working using numbers for my room types but I would like it to work with text eg replace the “1” with Room, “2” with Lift, “1” with Stairwell but I cannot get it to work. Is this possible or am I just not doing something right.

If [RoomType]="1" Then
RESULT ="R[FloorLevel].[Room_ID]"
ElseIf [RoomType]="2" Then
RESULT = "L[FloorLevel].[Room_ID]"
ElseIf [RoomType]="3"Then
RESULT = "S[FloorLevel].[Room_ID]"
Else
RESULT ="SD[FloorLevel].[Room_ID]"
End If

[stelthorst]

Hi douglas,

Try putting the RoomType in quotes.

If "[RoomType]" = "1" Then
RESULT = "R[FloorLevel].[Room_ID]"
ElseIf "[RoomType]" = "2" Then
RESULT = "L[FloorLevel].[Room_ID]"
ElseIf "[RoomType]" = "3" Then
RESULT = "S[FloorLevel].[Room_ID]"
Else
RESULT = "SD[FloorLevel][Room_ID]"
End If

It worked for me when I did it.

Hope this helps,