MULTIPLYING BY DECIMAL RETURNING INCORRECT RESULT

(1) Share

Report

Posted on by chudson002

211

Hello Community,

The formula below is for a field named Total:

Text(Value(TA.Text) + Value(GA.Text), "[$-en-US]$#,###.00") = $1,049,218.27

$797,824.50 $251,393.77

Calculates great but, when multiplying the result by a decimal, it returns an incorrect value.
Text(Value(TA.Text) + Value(GA.Text) * 0.005, "[$-en-US]$#,###.00") = $799,081.47 (PowerApp result)
$1,049,218.27 x 0.005 = $5,246.09

Any suggestions on what the formula should be?

Thanks,

V/R

chudson002

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Pstork1 69,653 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
I didn't test this, but I believe you need to add parentheses around the addition of the two values or you are only multiplying the second value by the decimal.

Text((Value(TA.Text) + Value(GA.Text)) * 0.005, "[$-en-US]$#,###.00") = $799,081.47 (PowerApp result)

Was this reply helpful? Yes No
Verified answer

Bochie 237 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @chudson002 ,

it was multiplying $251,393.77 to .005 first then adding $797,824.50. Try this instead:
((Text(Value(TA.Text) + Value(GA.Text)) * 0.005, "[$-en-US]$#,###.00")

hope this helps

Was this reply helpful? Yes No
chudson002 211 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, you were right,
(Text((Value(TA.Text) + Value(GA.Text)) * 0.005, "[$-en-US]$#,###.00")).

Thanks.

Was this reply helpful? Yes No
chudson002 211 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, had to remove one parens.
(Text((Value(VA.Text) + Value(OGA.Text)) * 0.005, "[$-en-US]$#,###.00"))

Thanks so much!
V/R
chudson002

Was this reply helpful? Yes No