https://communities.sas.com/t5/SAS-Visual-Analytics/Getting-an-error-to-create-a-calculated-item-in-sasviya/m-p/614917#M13398 <P>If I going to create a new calculated item, I am getting an error like the below screenshot.</P><P>Note:-&nbsp; &nbsp;My calculated item like this&nbsp;</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <STRONG>&nbsp;distinct (employees) / Avg(Working employees)---Getting error like below screenshot</STRONG></P><P>If I use &nbsp;distinct (employees), Avg(Working employees) in&nbsp; KPI Objects I am getting correct results</P><P>Can anyone suggest me for this?</P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks in advance,</P><P>Kiran</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SAS error.PNG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/35120iCB28048895C9C320/image-size/large?v=v2&amp;px=999" role="button" title="SAS error.PNG" alt="SAS error.PNG" /></span></P> Fri, 03 Jan 2020 06:53:01 GMT kiranch 2020-01-03T06:53:01Z https://communities.sas.com/t5/SAS-Visual-Analytics/Getting-an-error-to-create-a-calculated-item-in-sasviya/m-p/614917#M13398 <P>If I going to create a new calculated item, I am getting an error like the below screenshot.</P><P>Note:-&nbsp; &nbsp;My calculated item like this&nbsp;</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <STRONG>&nbsp;distinct (employees) / Avg(Working employees)---Getting error like below screenshot</STRONG></P><P>If I use &nbsp;distinct (employees), Avg(Working employees) in&nbsp; KPI Objects I am getting correct results</P><P>Can anyone suggest me for this?</P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks in advance,</P><P>Kiran</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SAS error.PNG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/35120iCB28048895C9C320/image-size/large?v=v2&amp;px=999" role="button" title="SAS error.PNG" alt="SAS error.PNG" /></span></P> Fri, 03 Jan 2020 06:53:01 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Getting-an-error-to-create-a-calculated-item-in-sasviya/m-p/614917#M13398 kiranch 2020-01-03T06:53:01Z https://communities.sas.com/t5/SAS-Visual-Analytics/Getting-an-error-to-create-a-calculated-item-in-sasviya/m-p/614918#M13399 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/162842">@kiranch</a>&nbsp;, Have you referred this SAS Support Link, it might help you:</P> <P><A href="http://support.sas.com/kb/64/945.html" target="_blank">http://support.sas.com/kb/64/945.html</A>&nbsp;</P> Fri, 03 Jan 2020 06:59:11 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Getting-an-error-to-create-a-calculated-item-in-sasviya/m-p/614918#M13399 Kalind_Patel 2020-01-03T06:59:11Z