Reduce decimals to 1

(0) Share

Report

Posted on by PeterKuehlian

I am trying to get a solution of a calculation in my flow with only one decimal.

Here is my flow:

I am picking up the file Size of my document and want to create exact the same value in another column. The purpose of this is, that I want to check if the content of my document has changed or not.

So in this flow my file size is at 53.100000000917841. I want it to be 53.1.

Once this is done i just add KB to the string and i can compare it to my metadata-field Document Size. (Hopefully 😉 )

Thanks in advance

Peter

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Willemijn 214 on at

Like (0)

Report

Re: Reduce decimals to 1

Hi!

You first need to convert the float to a string and then you could use substring in combination with indexOf for that: substring(string(variables('decimal Value')),0,add(2,indexOf(string(variables('decimal Value')),'.')))
result:

Was this reply helpful? Yes No
PeterKuehlian 79 on at

Like (0)

Report

Re: Reduce decimals to 1

Hi

That works great.

Only one more thing I need to apply.
I have to round my decimal correctly.
In the example in the picture, I want the full number to be 53.1

Was this reply helpful? Yes No