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

Unanswered

How to subtract fornulas

(0) Share

Report

Report

Posted on by dylandavis09

438

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report
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!

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report

SOLVED! 🙂

Was this reply helpful? Yes No

Join the conversation