Shopping Cart total amount using If function and Checkbox condition for a roundup

(1) Share

Report

Posted on by GaëlleMAS

Hi community,

I'm trying to find the right formula to calculate :

1- the Sum of my collection Shopping cart (as a Subtotal)

2- If a RoundUp CheckBox is ticked, then to Roundup the SubTotal, if not to keep the originalo SubTotal

3- to Add a Value from a TextInput for additional donation (for charity)

Here is what I was doing but It doesn't work and I don't know what to change:

With( {ST: If(Checkbox_RoundUp,RoundUp(Sum(ColshoppingCart,SousTotal)),Sum(ColshoppingCart, SousTotal)) + DonInput} , "Total de la commande: " & Text( ST, "##0.00 #€"))

Thanks for your help.

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @GaëlleMAS ,
Is DonInput a variable or name of the control ?
Click on "ST" in the formula to chec what value you are getting in SP variable.
With( {ST: If(Checkbox_RoundUp, RoundUp(Sum(ColshoppingCart,SousTotal)), Sum(ColshoppingCart, SousTotal)) + Value(DonInput) } , "Total de la commande: " & Text( ST, "##0.00 #€"))
KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @GaëlleMAS,

How does the code not work? For example, does it give errors / show an incorrect value / give an incorrect format, etc?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.
GaëlleMAS 13 on at

Like
a
(1)

Report
Copy link

Link copied!

@NandiniBhagya20 DonInput is a Label, not a Variable and actually this portion is the piece which works fine, the issue looks to be with the RoundUp to make it work and add it to the rest of the Calculation.

@KeithAtherton this is what I'm getting, and the play doesn't even showup I have a Red Cross on my Label.

THanks all for prompt reply
KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. Try changing Checkbox_RoundUp to Checkbox_RoundUp.Value.

If you get any more errors, continue to hover over them to get more detail.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.
GaëlleMAS 13 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried this as well but not working either unfortunately
I wanted to try to do the RoundUp 1st as a Variable set but the condition is making anything I'm trying to fail, so I guess something is wrong in the way I'm trying to do it.
If anybody has any other suggestion, please let me know.

Thanks.
Verified answer

LaurensM 12,516 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @GaëlleMAS,

The RoundUp function expects 2 parameters: RoundUp(Number, DecimalPlaces)

If you want a whole number try:

RoundUp(Sum(ColshoppingCart,SousTotal), 0)

Feel free to adjust the decimal places parameter to your specific needs. You can find the documentation on all of the different Rounding functions here.

I hope this helps!
GaëlleMAS 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LaurensM
Thank you very much, I tried so many thing yesterday that I couldn't rember what I've already tried, I'm pretty sure I've tried this as well, but I may have generated other mistake as if wasn't working, now it is !

Thanks very much ! You make my day !