web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Getting the right form...

Power Apps

Unanswered

Getting the right formula for Subtotal and Order total

(0) Share

Report

Report

Posted on by Nneka

50

Hello

Please I need help with getting the right formula for my order total because the formulas I tried are not working.

I used a drop down for the order qty and a text label for the subtotal with the formula

Text(ThisItem.ItemPrice*Dropdown1.Selected.Value,”[$-en-US]$##,###.00”,en-US””)

Then the Order total

& Text((Sum(colshoppingCart ,SubTotal)))

It’s not working.

It says the value $80.00 cannot be converted to a number.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

Michael E. Gernaey 53,968 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@Nneka

Hi, the reason is you have a $ character in the SubTotal so it wont work. try this

Text(Sum(colshoppingCart ,Right(SubTotal,Len(SubTotal) -1)))

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Nneka 50 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Sir,
Thank you for your help.
The formula worked but how do I get the order total to display with the currency symbol and the tens and units.
Currently it’s showing as 80 and I want it to show as $80.00.

Was this reply helpful? Yes No
Nneka 50 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Sir
The formula worked but I noticed my order total no longer tallies with the subtotal.
I have 2 items in my cart 136 + 144=280
But the order total is showing 272

Was this reply helpful? Yes No

Join the conversation