web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to subtract fornulas

Power Apps

Answered

How to subtract fornulas

(0) Share

Report

Report

Posted on by dylandavis09

442

I am trying to find a way to subtract the values of two labels, like this: $45 - $20 = $25.

Shopping Cart Total: $45 (Label6_8)

Current Dragon Ticket: $20 (Label6_6)

To determine your remaining Dragon Ticket balance, subtract 'Label6_6' from 'Label6_8':

$45 - $20 = $25 (Label6_4)

Your Dragon Ticket balance is now $25 (Label6_4).

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @dylandavis09,

The issue is that your label is displaying a text value due to the added currency symbol. In case you have that value stored in a number column, you could subtract the values of those columns instead:

//Text property of your total label ColumnLabel6_8 - ColumnLabel6_6

In case that is not possible, we will have to remove the currency symbol from those labels before subtracting:

//Text property of your total label Substitute(Label6_8.Text, "$", "") - Substitute(Label6_6.Text, "$", "")

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
dylandavis09 442 on at

Like
a
(0)

Report
Copy link

Link copied!

SOLVED! 🙂

Join the conversation