Answered

Error in Minus Calculation

(0) Share

Report

Posted on by Phineas

5,331 Moderator

I need to get the sum of the first field minus the second field, but I'm only getting '0'.

Field 1 has - "$" & Edit_PO_Ex_Factory_Price2_Fld.Text

Field 2 has - "(" & Edit_PO_Deposit_Request_Fld.Text & ")"

Total has - Text(Sum(Invoice_Total_Price_Fld.Text) - Text(Invoice_Total_Price_Fld_2.Text))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
please try the following

Value(Substitute(Edit_PO_Ex_Factory_Price2_Fld.Text, "$", "")) - Value(Substitute(Substitute(Edit_PO_Deposit_Request_Fld.Text, "(", ""), ")", ""))

u need to change the text into a number format using the Value() function

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Yep, that did it.

It appears as - 242978.03

Can the formula be updated so that it appears as - $242,978.03

Was this reply helpful? Yes No
Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
please try this:

Text(Value(Substitute(Edit_PO_Ex_Factory_Price2_Fld.Text, "$", "")) - Value(Substitute(Substitute(Edit_PO_Deposit_Request_Fld.Text, "(", ""), ")", "")), "$#,###.00")

Was this reply helpful? Yes No