https://communities.sas.com/t5/SAS-Visual-Analytics/Getting-ratio-of-two-totaled-columns-in-sas-Visual-anlaytics-7-3/m-p/677434#M14115 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Thilan_0-1597745519110.png" style="width: 703px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/48370iEA501C065678D112/image-dimensions/703x288?v=v2" width="703" height="288" role="button" title="Thilan_0-1597745519110.png" alt="Thilan_0-1597745519110.png" /></span></P><P>Need to get the ratio from two total columns instead it sums up the whole ratios. The ratio of the total column should be something like (Os Balance Total/ No of accounts) TOTAL *100. Instead I'm getting the sum of all ratios as the total.&nbsp; The problem containing cells are highlighted in yellow. Please help me in finding a way to get the ratio of two totaled columns.</P> Tue, 18 Aug 2020 10:19:01 GMT Thilan 2020-08-18T10:19:01Z https://communities.sas.com/t5/SAS-Visual-Analytics/Getting-ratio-of-two-totaled-columns-in-sas-Visual-anlaytics-7-3/m-p/677434#M14115 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Thilan_0-1597745519110.png" style="width: 703px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/48370iEA501C065678D112/image-dimensions/703x288?v=v2" width="703" height="288" role="button" title="Thilan_0-1597745519110.png" alt="Thilan_0-1597745519110.png" /></span></P><P>Need to get the ratio from two total columns instead it sums up the whole ratios. The ratio of the total column should be something like (Os Balance Total/ No of accounts) TOTAL *100. Instead I'm getting the sum of all ratios as the total.&nbsp; The problem containing cells are highlighted in yellow. Please help me in finding a way to get the ratio of two totaled columns.</P> Tue, 18 Aug 2020 10:19:01 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Getting-ratio-of-two-totaled-columns-in-sas-Visual-anlaytics-7-3/m-p/677434#M14115 Thilan 2020-08-18T10:19:01Z https://communities.sas.com/t5/SAS-Visual-Analytics/Getting-ratio-of-two-totaled-columns-in-sas-Visual-anlaytics-7-3/m-p/677443#M14116 <P>Hello&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/303742">@Thilan</a>&nbsp;</P> <P>&nbsp;</P> <P>I believe you need to use aggregated operators in calculation i.e.&nbsp;<FONT face="courier new,courier" color="#808080">Sum [_ByGroup_] ({Number}).</FONT></P> <P>&nbsp;</P> <P><FONT face="arial,helvetica,sans-serif" color="#000000">Best regards,</FONT></P> <P><FONT face="arial,helvetica,sans-serif" color="#000000">Petri</FONT></P> Tue, 18 Aug 2020 11:54:06 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Getting-ratio-of-two-totaled-columns-in-sas-Visual-anlaytics-7-3/m-p/677443#M14116 PetriRoine 2020-08-18T11:54:06Z