topic Re: Calculated Measure - If Else in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Calculated-Measure-If-Else/m-p/931587#M18084 <P>Hey&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/462152">@krnkva</a>! You cannot return characters with aggregated functions, but you can return numbers. In your case, you can use a binary 1/0 indicator for repeated customers. For example:</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Stu_SAS_2-1718038772434.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/97189i9C5E95D6EA024B67/image-size/medium?v=v2&amp;px=400" role="button" title="Stu_SAS_2-1718038772434.png" alt="Stu_SAS_2-1718038772434.png" /></span></P> Mon, 10 Jun 2024 17:00:33 GMT Stu_SAS 2024-06-10T17:00:33Z Calculated Measure - If Else https://communities.sas.com/t5/SAS-Visual-Analytics/Calculated-Measure-If-Else/m-p/931115#M18081 <P>Hi, I would like to know how I can solve this error? Thanks.<BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/97062iC750B47FA43CCC46/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Thu, 06 Jun 2024 12:46:04 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Calculated-Measure-If-Else/m-p/931115#M18081 krnkva 2024-06-06T12:46:04Z Re: Calculated Measure - If Else https://communities.sas.com/t5/SAS-Visual-Analytics/Calculated-Measure-If-Else/m-p/931587#M18084 <P>Hey&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/462152">@krnkva</a>! You cannot return characters with aggregated functions, but you can return numbers. In your case, you can use a binary 1/0 indicator for repeated customers. For example:</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Stu_SAS_2-1718038772434.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/97189i9C5E95D6EA024B67/image-size/medium?v=v2&amp;px=400" role="button" title="Stu_SAS_2-1718038772434.png" alt="Stu_SAS_2-1718038772434.png" /></span></P> Mon, 10 Jun 2024 17:00:33 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Calculated-Measure-If-Else/m-p/931587#M18084 Stu_SAS 2024-06-10T17:00:33Z