https://community.esri.com/t5/arcgis-experience-builder-questions/dynamic-expression-percentage-year-over-year/m-p/1533989#M14658 <P>Is it possible to populate a text box with a dynamic expression as a percentage?&nbsp;&nbsp;</P><P>I have <EM><STRONG>[Instance_Count] </STRONG></EM>and <EM><STRONG>[Previous_Year_Count]</STRONG></EM>.&nbsp; I can use Arcare to calculate the Change<EM><STRONG> [Incident_Change]</STRONG></EM> as "$feature.Instance_Count - $feature.Previous_Year_Count"&nbsp; However, I would like to show this change divided (/) by the&nbsp;<EM><STRONG>[Previous_Year_Count]</STRONG></EM>.&nbsp; It seems you are not able to write these long expressions.&nbsp; Can you please advise how this can be accomplished.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="GISOurData_0-1725253369674.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/114122i69176813939DC1BB/image-size/medium?v=v2&amp;px=400" role="button" title="GISOurData_0-1725253369674.png" alt="GISOurData_0-1725253369674.png" /></span></P><P>&nbsp;</P> Mon, 02 Sep 2024 05:06:46 GMT GISOurData 2024-09-02T05:06:46Z https://community.esri.com/t5/arcgis-experience-builder-questions/dynamic-expression-percentage-year-over-year/m-p/1533989#M14658 <P>Is it possible to populate a text box with a dynamic expression as a percentage?&nbsp;&nbsp;</P><P>I have <EM><STRONG>[Instance_Count] </STRONG></EM>and <EM><STRONG>[Previous_Year_Count]</STRONG></EM>.&nbsp; I can use Arcare to calculate the Change<EM><STRONG> [Incident_Change]</STRONG></EM> as "$feature.Instance_Count - $feature.Previous_Year_Count"&nbsp; However, I would like to show this change divided (/) by the&nbsp;<EM><STRONG>[Previous_Year_Count]</STRONG></EM>.&nbsp; It seems you are not able to write these long expressions.&nbsp; Can you please advise how this can be accomplished.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="GISOurData_0-1725253369674.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/114122i69176813939DC1BB/image-size/medium?v=v2&amp;px=400" role="button" title="GISOurData_0-1725253369674.png" alt="GISOurData_0-1725253369674.png" /></span></P><P>&nbsp;</P> Mon, 02 Sep 2024 05:06:46 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/dynamic-expression-percentage-year-over-year/m-p/1533989#M14658 GISOurData 2024-09-02T05:06:46Z https://community.esri.com/t5/arcgis-experience-builder-questions/dynamic-expression-percentage-year-over-year/m-p/1534907#M14690 <P>It would look something like below.&nbsp; This would be configured to operate on the selection view of a specific layer, so that when a feature is selected it makes the calculation for that feature.&nbsp; If multiple features are selected it is calculating based on the sum of all features.</P><LI-CODE lang="javascript">((SUM({Instance_Count}) - SUM({Previous_Year_Count})) / SUM({Previous_Year_Count})) * 100 + "%"</LI-CODE><P>&nbsp;</P> Wed, 04 Sep 2024 13:55:33 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/dynamic-expression-percentage-year-over-year/m-p/1534907#M14690 Marshal 2024-09-04T13:55:33Z