How can we help you today?

Known Issue: Decimals are Displayed in ShortPoint Connections Despite the Calculated Column Having 0 Decimal Places

Issue


After setting 0 as a Number of decimal places for the calculated column in your SharePoint list, you can still see the decimals displayed in the ShortPoint Design Element connected to that list:


Calculated column settings
ShortPoint Design Element connected to the list


However, if you check the SharePoint list, it is showing no decimals:



Reason


ShortPoint Connections always display data in the way SharePoint returns it in the JSON, without any modifications. For the calculated columns the data is always returned with decimals. 


By setting Number of decimal places for the calculated column you can add the internal conversion and define the number of decimal places to be displayed in the SharePoint. However, it does not influence the originally fetched data used in the ShortPoint Connections.


Workaround


As a workaround you can modify the formula used for the calculated column. Please follow the steps below.


Click the cog wheel icon in the top right corner of the page to open the Settings. Choose the List settings from the options: 



Locate your calculated column under the Columns section and click it to open its settings:



Here is the formula you can use to hide the decimals:


=TEXT([Column1]+[Column2]+[Column3],"#")


Note: You can define the number of decimals to display. For example, to show 2 decimal places, you need to add .00 after the hashtag symbol, like this: =TEXT([Column1]+[Column2]+[Column3],"#.00")


Substitute the column names in the formula with the column names in the list. For example, in our case it will look like this: 


=TEXT([Full timers]+[Part timers]+Freelancers,"#")


Copy and paste the modified formula to the respective field under the Additional Column Settings:



Scroll down to the bottom of the page and click OK to save your changes:



Result


Now, no decimals will be displayed in your ShortPoint Design Elements connected to SharePoint list with the calculated column:



Related articles:

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

World's best intranet sites are designed using ShortPoint

Get started today! Learn more
See all 14 topics

Start a trial

Ignite your vision. Install ShortPoint directly on your site, or play in sandbox mode. No credit card required.

Get started today

World's best intranet sites are designed using ShortPoint

Thousands of companies using ShortPoint everyday to design, brand and build award winning intranet sites.

Get started Learn more