Division by zero error

(0) Share

Report

Posted on by Fioravanti

I'm having a division by zero error where it doesn't show the result I need.

With(
 {
 _Hours:
 RoundDown(
 ThisItem.'Quantidade de horas';
 0
 )
 };
 Text(_Hours; "00") & ":" & 
 Text(
 Round(
 Mod(
 ThisItem.'Quantidade de horas';
 _Hours
 ) *60;
 2
 );
 "00"
 )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
I //THINK// that might resolve it, let me know

With( { _Hours: RoundDown( ThisItem.'Quantidade de horas'; 0 ) }; Text(_Hours; "00") & ":" & Text( IfError(Round( Mod( ThisItem.'Quantidade de horas'; _Hours ); 0) *60; 2 ); "00" ) )

Was this reply helpful? Yes No