Show extended text only when there is a single selection

[Anonymous]

I have a single table with several thousand rows.  One of the columns is "Short_Description" and another is "Extended_Description"

Since the extended description can be several sentences long, I would like to display it in a text box, but only if a single record in the table has been selected. If there are no, or multiple, selections, it should be blank.

As I am scrolling my chart with short descriptions, I should be able to click on a particular record and get the extended description in anothe robject.

[Anonymous]

Never mind - I was able to adapt from another post.  Thanks!

Text Box

=If(getSelectedCount([Short_Description])=1 andIsNotNull(Extended_Description])0,Extended_Description,0)

[Anonymous · Accepted solution]

Thnaks Rob.  I think that will work also.  Now I wish I could figure out how my reply to my post got posted 12 times...I kept getting an error saying it was unabe to post but apparently it was able!