Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Nintex Community
- :
- Forums
- :
- Nintex for SharePoint
- :
- After a calculation I need to display one decimal ...

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

After a calculation I need to display one decimal only, how I can do it?

Solved! Go to Solution.

10 Replies

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: After a calculation I need to display one decimal only, how I can do it?

Alex,

In the Properties of the Calculated Value you do have the option there to set the number of decimal places. This will limit the number of decimal places used in the calculation though - not just what is displayed. So it rounds the generated value to the decimal places stipulated.

If this is not what you want, you could have this calculated value generate the full number with whatever decimals are allowed and utilise a second Calculated value that would take the first value as an input and then set the required one decimal place in this one You would then use this one for your display, while hiding the original value.

Cheers,

Mark

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: After a calculation I need to display one decimal only, how I can do it?

Is your calculation in a form with a calculated value or in workflow with a Math operation action ?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: After a calculation I need to display one decimal only, how I can do it?

Caroline, I'm using Math operation action.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: After a calculation I need to display one decimal only, how I can do it?

Mark,

I don't have that properties of the calculated value (Math operation), only let me set the results in a variable.

Let me explain what I'm doing: I have multiple questions (Collected from InfoaPath form in to SharePoint) and each question has an score, If they answer the question Correctly I give the Numerator and Denominator variable a value and at the end I calculate the score by "Math Operation" of the 2 variables (Numerator devided Deniminator) and after that I multiply the new result by 100 and now I just need the score with just one decimal.

I hope you understand what I'm doing and trying to do.

Thank you for help out.

Alex

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: After a calculation I need to display one decimal only, how I can do it?

I forgot to mention is not NINTEX forms the issue, is on NINTEX workflows.

Thank you.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: After a calculation I need to display one decimal only, how I can do it?

Sorry Alex,

My assumption was that this was inside a Nintex Form. Are you storing the end result in a List Column? If so it would be a matter of defining the column to have one decimal place.

If this is not an option, as crazy as it may seem, there is no easy way to do this within the Workflow mechanism.

One way would be to add an Execute SQL control and utilise SQL functionality with a query similar to the below:

select convert(decimal(5,1),round({WorkflowVariable:varTestNumber},1))

Simply using a Round call will round the number, but leave zeroes in the place of the other trailing decimals. The Convert will take care of this.

Cheers,

Mark

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Not the Solution
- Email to a Friend
- Report Inappropriate Content

Another way to get a number with only one decimal in Nintex Workflow is to :

- use a Math operation action to multiply the number by 10
- use a Set variable action to round the previous number to the nearest integer :
- the variable to set has to be of type single line of text
- the value to set is : fn-Round(yourNumberVariable)

- use a Math operation action to divide the previous number (stored in a single line of text variable) by 10

Hope this helps

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: After a calculation I need to display one decimal only, how I can do it?

This is the solution in my case. It Works.

Thank you soo much Caroline.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: After a calculation I need to display one decimal only, how I can do it?

This is anothger good solution but implemented Caroline's.

Thank you both of you.