Answered

roundup power automate flow

(0) Share

Report

Posted on by KK76875875

105

Greetings!
I have a user input (my variable) and I want all of the numbers to be (in output after calculations): if it's more than 0 but less than 0.5 it's 0.5

0.5 it's 0.5

and everything that bigger than 0.5 it's 1

for example,

20.0 = 20.0

20.1 = 20.5

20.2 = 20.5

20.5 = 20.5

20.6 = 21.0

Can someone help me, please

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,830 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @KK76875875,

Try an expression like below:

if(equals(indexOf(string(outputs('Compose_2')), '.'), -1), outputs('Compose_2'), if(lessOrEquals(split(string(outputs('Compose_2')), '.')[1], '5'), concat(split(string(outputs('Compose_2')), '.')[0],'.5'), concat(add(int(split(string(outputs('Compose_2')), '.')[0]),1),'.0')))

Was this reply helpful? Yes No
KK76875875 105 on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus
Thank you so MUCH!
Absolute life saver!

Was this reply helpful? Yes No