Worksheet Formula - Door Id's

[TaylorK]

Hi All,

 

Im trying to create a calculated field in a worksheet that will display a Door Prefix,Label, & Suffix in one line.

 

ie

='Door'.'IDPrefix''Door'.'IDLabel''Door'.'IDSuffix'

 

But unfortunately it s eems the field in the report isn't calculating rather just displaying the formula. Is there something wrong with my syntax?  I was able to do something similar in a data tag for the doors. I understand a work around would be to make separate columns for each field but I would love to be able to do this for simpliciy sake. 

 

Thanks!

[Pat Stanford]

I think you need to use CONCAT to put multiple fields into a single cell.

 

=CONCAT('Door'.'IDPrefix','Door'.'IDLabel','Door'.'IDSuffix')

 The above example is for the US where the different fields are separate by commas.  In other locations (Europe for example), the separator is a semicolon (;)

 

 

[TaylorK]

That worked wonders! Thank you so much Pat