<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Expression for converting story numbers (counter) in Documentation</title>
    <link>https://community.graphisoft.com/t5/Documentation/Expression-for-converting-story-numbers-counter/m-p/584632#M62723</link>
    <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I want to pimp my Zone number in 1:50 scale to have this structure: unit-level-space, whereby:&lt;/P&gt;&lt;P&gt;- unit refers to apartment or some other programmatic unit and is an option set that I select in "ID and properties" menu&lt;/P&gt;&lt;P&gt;- level pulls Zone story number and changes its format a bit,&lt;/P&gt;&lt;P&gt;- space refers to "Zone No:" and belongs to basic functionality of the Zone tool.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have set up another CONCAT expression to connect the three numerical values with "-" separator into desired structure.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;My question refers to the level part: Since story numbers can have negative values (basements, foundations), is there a function that would search for the smallest vallues of story numbers, count them and assign them a positive number like so:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;story&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;-&amp;gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;level&lt;/P&gt;&lt;P&gt;-2&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 01&lt;/P&gt;&lt;P&gt;-1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;02&lt;/P&gt;&lt;P&gt;0&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;03&lt;/P&gt;&lt;P&gt;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 04&lt;/P&gt;&lt;P&gt;2&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;05&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Suggestions appreciated!&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Fri, 19 Jan 2024 08:22:49 GMT</pubDate>
    <dc:creator>Rastko Pecar</dc:creator>
    <dc:date>2024-01-19T08:22:49Z</dc:date>
    <item>
      <title>Expression for converting story numbers (counter)</title>
      <link>https://community.graphisoft.com/t5/Documentation/Expression-for-converting-story-numbers-counter/m-p/584632#M62723</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I want to pimp my Zone number in 1:50 scale to have this structure: unit-level-space, whereby:&lt;/P&gt;&lt;P&gt;- unit refers to apartment or some other programmatic unit and is an option set that I select in "ID and properties" menu&lt;/P&gt;&lt;P&gt;- level pulls Zone story number and changes its format a bit,&lt;/P&gt;&lt;P&gt;- space refers to "Zone No:" and belongs to basic functionality of the Zone tool.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have set up another CONCAT expression to connect the three numerical values with "-" separator into desired structure.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;My question refers to the level part: Since story numbers can have negative values (basements, foundations), is there a function that would search for the smallest vallues of story numbers, count them and assign them a positive number like so:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;story&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;-&amp;gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;level&lt;/P&gt;&lt;P&gt;-2&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 01&lt;/P&gt;&lt;P&gt;-1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;02&lt;/P&gt;&lt;P&gt;0&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;03&lt;/P&gt;&lt;P&gt;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 04&lt;/P&gt;&lt;P&gt;2&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;05&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Suggestions appreciated!&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 19 Jan 2024 08:22:49 GMT</pubDate>
      <guid>https://community.graphisoft.com/t5/Documentation/Expression-for-converting-story-numbers-counter/m-p/584632#M62723</guid>
      <dc:creator>Rastko Pecar</dc:creator>
      <dc:date>2024-01-19T08:22:49Z</dc:date>
    </item>
    <item>
      <title>Re: Expression for converting story numbers (counter)</title>
      <link>https://community.graphisoft.com/t5/Documentation/Expression-for-converting-story-numbers-counter/m-p/586926#M62880</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;This is a bit of a late reply.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You could use a formula that computes:&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;3+Story Number&lt;/STRONG&gt; to get you the second digit of the the level you want.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Example:&lt;/P&gt;&lt;TABLE border="1" width="100%"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD width="50%" height="30px"&gt;&lt;STRONG&gt;Story&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD width="50%" height="30px"&gt;&lt;STRONG&gt;Formula result&lt;/STRONG&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%" height="30px"&gt;-2&lt;/TD&gt;&lt;TD width="50%" height="30px"&gt;3+(-2) = 1&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%" height="30px"&gt;-1&lt;/TD&gt;&lt;TD width="50%" height="30px"&gt;3+(-1) = 2&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%" height="30px"&gt;0&lt;/TD&gt;&lt;TD width="50%" height="30px"&gt;3+0 = 3&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;etc.&lt;/TD&gt;&lt;TD width="50%"&gt;&amp;nbsp;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;To get the 0 before the number, I think you'll have to convert it to a text value and concatenate. Try:&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;CONCAT ( "0"; STR ( 3 + Story Number; 0 ) )&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;This is quite an inflexible numbering system though, as it means level 01 refers to something different depending on how many lower levels you have, project to project. And if your lowest level changes, you need to adapt the 3 to another number.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Best regards&lt;/P&gt;&lt;P&gt;AK&lt;/P&gt;</description>
      <pubDate>Tue, 06 Feb 2024 10:39:33 GMT</pubDate>
      <guid>https://community.graphisoft.com/t5/Documentation/Expression-for-converting-story-numbers-counter/m-p/586926#M62880</guid>
      <dc:creator>ak1000CH16</dc:creator>
      <dc:date>2024-02-06T10:39:33Z</dc:date>
    </item>
  </channel>
</rss>

