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.