Round or RoundUp Formula

(0) Share

Report

Posted on by RJF61

1,265

Hello,

I have the following formula...

Round(mul(div(sub(outputs('Compose_6'),outputs('Compose_7')),5),3),1).

The portion mul(div(sub(outputs('Compose_6'),outputs('Compose_7')),5),3) works fine; however, when I add Round or RoundUp, I receive the following error...

Unable to process template language expressions in action 'Compose_5' inputs at line '0' and column '0': 'The template function 'Round' is not defined or not valid.'.

Can someone see my error?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @RJF61,

Unfortunately, the functions round and roundup do not exist in the expression language. This is the list of available math functions:

https://learn.microsoft.com/en-gb/azure/logic-apps/workflow-definition-language-functions-reference#math-functions

As a workaround, you could actually try and use a formatnumber with the # specifier.

With the ## format

1.4 will be 1

1.6 will be rounded up to 2

Try this expression:

formatnumber(float(outputs('Compose')), '##')

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus Thanks for the response. So without some Flow work, there is no current way to RoundUp (i.e., 13.2 becomes 14)?

Was this reply helpful? Yes No
Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @RJF61,

It should be possible to include that in your current expression.

I am currently not near my computer but I will create an example with your specific expression and update this post 🙂

Was this reply helpful? Yes No
Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @RJF61,

Let's say the output would be in Compose 12 and the data is of type string.

In that case you could use something like below:

if(equals(split(outputs('Compose_12'), '.')[1], 0), int(split(outputs('Compose_12'), '.')[0]), add(int(split(outputs('Compose_12'), '.')[0]), 1))

Was this reply helpful? Yes No