Repeating rows in gallery with 4 checkboxes

[Dorinda]

I have a gallery that is part of a repeating row (table) in the gallery.  I have 4 checkboxes in the gallery breakfast, lunch, dinner, all.

I need to be able to click on the All checkbox and have it select all of the other checkboxes.  I need it to be IN the gallery because it is a repeating row and not an outside button.

Can this be done?

Thanks

[Dorinda]

So I sort of have this working,

Text(Sum(If(Checkbox3.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Breakfast)
+
If(Checkbox3_1.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Dinner)
+
If(Checkbox3_2.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Lunch)
+
If(Checkbox3_3.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Incidentals)
)
)))),"[$-en-US]$#,###.00")

However, it is really not responding like i want so the first two Breakfast and Dinner will add up and ALL will add them all, but I need it to provide the total if just lunch and dinner or breakfast and Lunch.

I am close just missing something somewhere.

[Dorinda · Accepted solution]

Ok I figured it out.  I have my closing parenthesis in the wrong spots works perfect now.

ext(Sum(If(Checkbox3.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Breakfast))
+
If(Checkbox3_1.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Dinner))
+
If(Checkbox3_2.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Lunch))
+
If(Checkbox3_3.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Incidentals))
)
,"[$-en-US]$#,###.00")

[Mari]

Thanks for sharing your findings!