https://community.incorta.com/t5/dashboards-analytics-discussions/how-to-calculate-max-value-for-each-row/m-p/5224#M582 <P>Incorta does have a built in function to find the <A href="https://docs.incorta.com/cloud/references-built-in-functions-arithmetic-max" target="_blank" rel="noopener">max</A> between two values.&nbsp;</P><P>It won't be pretty, but using this you should be able to nest them in a way to find the max value between a number of columns.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="max1.PNG" style="width: 400px;"><img src="https://community.incorta.com/t5/image/serverpage/image-id/2487iC8164FDB15C9179D/image-size/medium?v=v2&amp;px=400" role="button" title="max1.PNG" alt="max1.PNG" /></span></P><P>  </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="max2.PNG" style="width: 400px;"><img src="https://community.incorta.com/t5/image/serverpage/image-id/2488iEC1F50DDE0E3B556/image-size/medium?v=v2&amp;px=400" role="button" title="max2.PNG" alt="max2.PNG" /></span></P><P>&nbsp;</P><P>Brandon</P> Wed, 01 Nov 2023 15:53:19 GMT BrandonR 2023-11-01T15:53:19Z https://community.incorta.com/t5/dashboards-analytics-discussions/how-to-calculate-max-value-for-each-row/m-p/5216#M580 <P>Hi Team,</P><P>I Have below requirement to calculate MAX value of 6 columns for each row. Please let me know how to achieve.</P><P>sample Data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KHK_0-1698834916691.png" style="width: 400px;"><img src="https://community.incorta.com/t5/image/serverpage/image-id/2483i82D597E876CE2EC7/image-size/medium?v=v2&amp;px=400" role="button" title="KHK_0-1698834916691.png" alt="KHK_0-1698834916691.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 01 Nov 2023 10:35:45 GMT https://community.incorta.com/t5/dashboards-analytics-discussions/how-to-calculate-max-value-for-each-row/m-p/5216#M580 KHK 2023-11-01T10:35:45Z https://community.incorta.com/t5/dashboards-analytics-discussions/how-to-calculate-max-value-for-each-row/m-p/5224#M582 <P>Incorta does have a built in function to find the <A href="https://docs.incorta.com/cloud/references-built-in-functions-arithmetic-max" target="_blank" rel="noopener">max</A> between two values.&nbsp;</P><P>It won't be pretty, but using this you should be able to nest them in a way to find the max value between a number of columns.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="max1.PNG" style="width: 400px;"><img src="https://community.incorta.com/t5/image/serverpage/image-id/2487iC8164FDB15C9179D/image-size/medium?v=v2&amp;px=400" role="button" title="max1.PNG" alt="max1.PNG" /></span></P><P>  </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="max2.PNG" style="width: 400px;"><img src="https://community.incorta.com/t5/image/serverpage/image-id/2488iEC1F50DDE0E3B556/image-size/medium?v=v2&amp;px=400" role="button" title="max2.PNG" alt="max2.PNG" /></span></P><P>&nbsp;</P><P>Brandon</P> Wed, 01 Nov 2023 15:53:19 GMT https://community.incorta.com/t5/dashboards-analytics-discussions/how-to-calculate-max-value-for-each-row/m-p/5224#M582 BrandonR 2023-11-01T15:53:19Z https://community.incorta.com/t5/dashboards-analytics-discussions/how-to-calculate-max-value-for-each-row/m-p/5225#M583 <P>Thank you&nbsp;<a href="https://community.incorta.com/t5/user/viewprofilepage/user-id/408">@BrandonR</a>&nbsp;, formula working fine.</P><P>&nbsp;</P> Thu, 02 Nov 2023 10:05:01 GMT https://community.incorta.com/t5/dashboards-analytics-discussions/how-to-calculate-max-value-for-each-row/m-p/5225#M583 KHK 2023-11-02T10:05:01Z