News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps How to subtract fornulas

Power Apps - Building Power Apps

Answered

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:

Using Apps Using Formulas

General Questions

Connecting to Data

All responses Img

All responses (2)

Answers Img

Answers (1)

dylandavis09 438 on at

Like (0)

Report

Re: How to subtract fornulas

SOLVED! 🙂
Verified answer

LaurensM 12,510 Super User 2025 Season 1 on at

Like (0)

Report
Re: How to subtract fornulas

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!