After a calculation I need to display one decimal only, how I can do it?
Another way to get a number with only one decimal in Nintex Workflow is to :
Hope this helps
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.
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.
Is your calculation in a form with a calculated value or in workflow with a Math operation action ?
Caroline, I'm using Math operation action.
I forgot to mention is not NINTEX forms the issue, is on NINTEX workflows.
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:
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.
This is the solution in my case. It Works.
Thank you soo much Caroline.
I'm glad that I could have helped you
This is anothger good solution but implemented Caroline's.
Thank you both of you.
Retrieving data ...