Answered

Calculating with a value operator

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello!

Currently I am calculating something using this formulas:

Set(
 sumTijdTotaal,
 Sum(
 colUrenRegistratie,
 TijdTotaal
 )
);
Set(
 remainder,
 8 - Mod(
 sumTijdTotaal,
 8
 )
);

And also this formula:

 Patch(
 UrenRegistratie,
 Defaults(UrenRegistratie),
 EditForm1.Updates,
 {TijdTotaal: Value(EditForm1.Updates.TijdTotaal) - remainder}
 );

The first formula basically sums up all of the hours on the Tijdtotaal column in my database. This is a number value. The second one uses the mod function by 8 and gets the remainder of it. So if you have the value 9, the remainder will be 1.

In the second formula, I just use the patch function to send information to my database. I do Tijdtotaal - the remainder and put that in the tijdtotaal column.

For some reasons this formula works good when only using full numbers. But as soon as I get a number with a comma, it removed the comma and sends it to the database.

So if I have a 6,25 it will write it as 625

What can I do about this?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

troytec 53 on at

Like
a
(1)

Report
Copy link

Link copied!
When I troubleshoot things like that I use a label as the final value I am going to patch to my database. Use a label and set its text to your Tijdtotaal.

To me it sounds like the final outcome isn't coming out as a value but as text perhaps. Maybe try patching this:
TijdTotaal: Value(EditForm1.Updates.TijdTotaal - remainder)

Always worth giving it a go.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your answer @troytec !

The formula you provided me does not change anything sadly.

Was this reply helpful? Yes No
troytec 53 on at

Like
a
(0)

Report
Copy link

Link copied!

Create a variable that stores your calculation: totaal - remainder ?

Then place a label on the screen and set its text property to your calculation. Don't patch anything just yet. We need to see the final outcome.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I tried to do that, here is the outcome @troytec

https://gyazo.com/85a003aa936f185652acbdae0eb82a13

You can see both values are stated as "Number" but the end result gives "" which is equal to nothing.

Was this reply helpful? Yes No
troytec 53 on at

Like
a
(1)

Report
Copy link

Link copied!
Hmm, I have never used EditForm1.Updates to get data values.

Try doing this:

//Set your tijdtotaal

Set( sumTijdTotaal, Sum( colUrenRegistratie, TijdTotaal ) );

//Set your remainder

Set( remainder, 8 - Mod( sumTijdTotaal, 8 ) );

//Set a new variable for your calculation
Set(varTijdTotaal, 'Insert your calculation here');

Then your patch becomes:
Patch( UrenRegistratie, Defaults(UrenRegistratie), EditForm1.Updates, {TijdTotaal: varTijdTotaal} );

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Fixed it by putting some values to single line text instead of number

Was this reply helpful? Yes No