topic Re: Different calculation output in list table vs crosstab in SAS Viya https://communities.sas.com/t5/SAS-Viya/Different-calculation-output-in-list-table-vs-crosstab/m-p/932612#M2444 <P>What language are you programming in?</P> Mon, 17 Jun 2024 12:56:42 GMT Astounding 2024-06-17T12:56:42Z Different calculation output in list table vs crosstab https://communities.sas.com/t5/SAS-Viya/Different-calculation-output-in-list-table-vs-crosstab/m-p/932436#M2443 <P>Hi all,</P><P>I have created this calculation to show the number of hours in 2024 and added it to my list table:</P><P>&nbsp;</P><PRE>IF ( 'Document_date_year'n = '2024'd ) RETURN ( IF ( 'Hours'n Missing ) RETURN 0 ELSE 'Hours'n ) ELSE 0</PRE><P>It works, but it shows the number of hours for each time a person entered their hours instead of just a count for each person.</P><P>Thats why I created a crosstab instead so that it sums the total number of hours per person. But now the above calculation is not working and it just shows 0.</P><P>&nbsp;</P><P><FONT color="#FF0000"><STRONG>List table output</STRONG></FONT></P><TABLE border="1"><TBODY><TR><TD>Person A</TD><TD>8</TD></TR><TR><TD>Person A</TD><TD>8</TD></TR><TR><TD>Person A</TD><TD>8</TD></TR><TR><TD>Person B</TD><TD>8</TD></TR><TR><TD>Person B</TD><TD>8</TD></TR><TR><TD>Person C</TD><TD>8</TD></TR><TR><TD>Person C</TD><TD>4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><FONT color="#339966"><STRONG>Desired output</STRONG></FONT></P><TABLE border="1"><TBODY><TR><TD>Person A</TD><TD>24</TD></TR><TR><TD>Person B</TD><TD>16</TD></TR><TR><TD>Person C</TD><TD>12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Does someone understand why this happens?</P><P>&nbsp;</P><P>Thanks in advance!</P> Fri, 14 Jun 2024 15:16:28 GMT https://communities.sas.com/t5/SAS-Viya/Different-calculation-output-in-list-table-vs-crosstab/m-p/932436#M2443 user34567 2024-06-14T15:16:28Z Re: Different calculation output in list table vs crosstab https://communities.sas.com/t5/SAS-Viya/Different-calculation-output-in-list-table-vs-crosstab/m-p/932612#M2444 <P>What language are you programming in?</P> Mon, 17 Jun 2024 12:56:42 GMT https://communities.sas.com/t5/SAS-Viya/Different-calculation-output-in-list-table-vs-crosstab/m-p/932612#M2444 Astounding 2024-06-17T12:56:42Z Re: Different calculation output in list table vs crosstab https://communities.sas.com/t5/SAS-Viya/Different-calculation-output-in-list-table-vs-crosstab/m-p/932613#M2445 English (United Kingdom) Mon, 17 Jun 2024 13:02:13 GMT https://communities.sas.com/t5/SAS-Viya/Different-calculation-output-in-list-table-vs-crosstab/m-p/932613#M2445 user34567 2024-06-17T13:02:13Z