title: Error converting datatype nvarchar to numeric
body: <p>My Table Data</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Amount1</th>
  <th>Amount2</th>
  <th>Expected Result</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>100</td>
  <td>200</td>
  <td>4.17%</td>
  </tr>
  <tr>
  <td>A</td>
  <td>500</td>
  <td></td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>500</td>
  <td>B</td>
  <td></td>
  </tr>
  <tr>
  <td>20</td>
  <td>100</td>
  <td>1.67%</td>
  </tr>
  </tbody>
  </table>
  </div>
  <pre><code>CREATE TABLE [dbo].[tblData](
      [Amount1] [nvarchar](50) NULL,
      [Amount2] [nvarchar](50) NULL
  ) ON [PRIMARY]
  
  INSERT [dbo].[tblData] ([Amount1], [Amount2]) VALUES (N'100', N'200')
  INSERT [dbo].[tblData] ([Amount1], [Amount2]) VALUES (N'A', N'500')
  INSERT [dbo].[tblData] ([Amount1], [Amount2]) VALUES (N'', N'')
  INSERT [dbo].[tblData] ([Amount1], [Amount2]) VALUES (N'500', N'B')
  INSERT [dbo].[tblData] ([Amount1], [Amount2]) VALUES (N'20', N'100')
  </code></pre>
  <p>This works fine as expected when I run it on one line</p>
  <pre><code>SELECT TOP 1
      Concat(CAST((cast(Amount1 AS decimal(18,4))/(cast(Amount2 AS decimal(18,4))*12))*100 AS decimal(18,2)),'%') AS Result
  FROM tblData 
  </code></pre>
  <p>This fails when I run it on whole table</p>
  <pre><code>SELECT 
      Concat(CAST((cast(Amount1 AS decimal(18,4))/(cast(Amount2 AS decimal(18,4))*12))*100 AS decimal(18,2)),'%') AS Result
  FROM tblData
  </code></pre>
  <p>Returning the below error message.</p>
  <blockquote>
  <p>Error converting datatype nvarchar to numeric</p>
  </blockquote>