https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-decimal-values-after-creating-calculated-item/m-p/598015#M13232 <P>Hi,</P><P>&nbsp;</P><P>After creating calculated items from date-time values, the numerical data that is displayed is accompanied by .00 decimal values. I have tried to format the data. However, that step only works in the data exploration tab and not in the report designer tab. So, how do I remove the decimal values after each of the data? Attached below is the formula that I used to create the table and the outcome after using the formula.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture1.JPG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/33315i43DCB56C7224E336/image-size/large?v=v2&amp;px=999" role="button" title="Capture1.JPG" alt="Capture1.JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture2.JPG" style="width: 215px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/33314iDB3467CCE24AA6A2/image-dimensions/215x170?v=v2" width="215" height="170" role="button" title="Capture2.JPG" alt="Capture2.JPG" /></span></P><P>&nbsp;</P><P>Regards</P><P>Dan</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 21 Oct 2019 03:47:05 GMT DandarahZ 2019-10-21T03:47:05Z https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-decimal-values-after-creating-calculated-item/m-p/598015#M13232 <P>Hi,</P><P>&nbsp;</P><P>After creating calculated items from date-time values, the numerical data that is displayed is accompanied by .00 decimal values. I have tried to format the data. However, that step only works in the data exploration tab and not in the report designer tab. So, how do I remove the decimal values after each of the data? Attached below is the formula that I used to create the table and the outcome after using the formula.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture1.JPG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/33315i43DCB56C7224E336/image-size/large?v=v2&amp;px=999" role="button" title="Capture1.JPG" alt="Capture1.JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture2.JPG" style="width: 215px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/33314iDB3467CCE24AA6A2/image-dimensions/215x170?v=v2" width="215" height="170" role="button" title="Capture2.JPG" alt="Capture2.JPG" /></span></P><P>&nbsp;</P><P>Regards</P><P>Dan</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 21 Oct 2019 03:47:05 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-decimal-values-after-creating-calculated-item/m-p/598015#M13232 DandarahZ 2019-10-21T03:47:05Z https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-decimal-values-after-creating-calculated-item/m-p/598036#M13233 <P>Hi!</P> <P>You change the format in the data tab in the report designer.</P> <P>Select your new variable and click on "Format"</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 370px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/33316i101860D9682AD1D0/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> <P>&nbsp;</P> <P>Then select how many decimals you want <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 328px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/33317i171A02424D9172AB/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> <P>&nbsp;</P> <P>//Fredrik</P> Mon, 21 Oct 2019 06:33:56 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-decimal-values-after-creating-calculated-item/m-p/598036#M13233 FredrikE 2019-10-21T06:33:56Z