Flows - DIV function returns 0 when using Compose

(1) Share

Report

Posted on by Julien5

Hi,

I'm going round in circles trying to figure out what I'm doing wrong.

I have a variable figure that I want to divide by a fixed number but I can't get the formula to work as intended. The input shows as zero as shown in the flow results

Compose availability = div(outputs('Compose_-_Total_Task_Duration'),outputs('Compose_-_Availability_target'))

The results of the flow

thanks for taking the time to help.

All responses (7)

Answers (2)

Rydman 96 on at

Like (1)

Report

Re: Flows - DIV function returns 0 when using Compose

Hi,

Thanks for this. This little conundrum reminded me why it's so frustrating to code in Power Automate. Is there a comprehensive, yet concise, documentation where you could find this stuff? I've been coding for 40 years, yet I get stumped again and again by this kind of non-intuitive quirks. Thank God for the helpful community!
trice602 13,817 Super User 2025 Season 1 on at

Like (1)

Report

Re: Flows - DIV function returns 0 when using Compose

Hi @Julien5 ,

Nice to see these replies on Friday!
Julien5 17 on at

Like (1)

Report

Re: Flows - DIV function returns 0 when using Compose

Thank you both for your help, I couldn't figure why the formula worked with fixed integers but failed initially.
I made the changes and it worked nicely
trice602 13,817 Super User 2025 Season 1 on at

Like (0)

Report

Re: Flows - DIV function returns 0 when using Compose

Hi @ManishSolanki ,

Great job on your post too! I like seeing us both in here at the same time. I also learn a lot from you on posts I don't know the answer immediately; I always read your solutions and learn! 💯💯💯💯💯
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (1)

Report

Re: Flows - DIV function returns 0 when using Compose

Hi @trice602

Nice demonstration 👍

Thanks
Verified answer

ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (2)

Report
Re: Flows - DIV function returns 0 when using Compose

Hi @Julien5

You need to convert both numbers to float (decimal numbers) and the perform div operation.

Pls try the below expression:

div(float(outputs('Compose_-_Total_Task_Duration')),float(outputs('Compose_-_Availability_target')))

The above expression will return the results in decimal number.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks
Verified answer

trice602 13,817 Super User 2025 Season 1 on at

Like (2)

Report

Re: Flows - DIV function returns 0 when using Compose

Hi @Julien5 ,

You need to convert both values with float() to return the desired value, shown below.