Order total formula

[Nneka]

Hello

I have 2 items in my cart and their subtotals are $72.00 and $80.00 respectively.

But my order total is giving me a total of $144.00 which means it’s only summing up the first item in my cart.

How do I get it to sum all items in the cart?

Formula used.

”$”&Text(Sum(colShoppingCart,Right(SubTotal,Len(SubTotal)-1)))

[Rajkumar_404]

Hi @Nneka 

Try this

"$" & Text(Sum(colShoppingCart, SubTotal))

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

[Nneka]

Hello sir,

I already tried the above formula before and it didn’t work.

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

[v-qiaqi-msft]

HI @Nneka,

That depends on how you set the Label of subtotals, you must have it formatted into a currecy, please post the format formula.

I have found that you mentioned it in your previous reply, is the following how you calculate the subtotals?

ThisItem.ItemPrice*Dropdown1.Selected.Value

If so, I think you need to use the following formula:

Text(Sum(BrowseGallery1.AllItems,Value(Body1.Text)),"[$-en-US]$##,###.00","en-US")

Note that you need to refer to Gallery.AllItems, and the Label where you display the subtotals.

[Nneka]

Hello Sir

My subtotal is calculated as

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

The given formula didn’t work for the order total.

[v-qiaqi-msft]

HI @Nneka,

Just roll back to the original version, add another label within the Gallery and set it as below formula, you could make this label invisible

ThisItem.ItemPrice*Dropdown1.Selected.Value

Remember this new label name, then 

Text(Sum(BrowseGallery1.AllItems,Value(NewLabel.Text)),"[$-en-US]$##,###.00","en-US")

I use this because you are not referring to the data from the same source, so make the format string roll back to the original version.

[Rajkumar_404]

Hi @Nneka 

@v-qiaqi-msft given formula works fine in my side.

If doesn't work, try this formula.

If the 'SubTotal' field contains non-numeric values or empty strings, you can use the IfError function to handle those cases

Text(Sum('Checkout Gallery'.AllItems, IfError(Value(SubTotal.Text), 0)),"[$-en-US]$##,###.00","en-US")

IfError(Value(SubTotal.Text), 0): This part handles potential errors by using IfError.

If there's an error converting SubTotal.Text to a number, it will default to 0.

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

[Nneka]

This didn’t work

It only made my order total to become 0

[Nneka]

Please explain further.

Which original version and how do you mean make it invisible?

[Rajkumar_404 · Accepted solution]

Try this one

Text(Sum('Checkout Gallery'.AllItems, Value(Substitute(SubTotal.Text, "$", ""))),"[$-en-US]$##,###.00","en-US")

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.