Repeating Field Question

[Nestor]

I have a field name "Chargeback" with 6 repetitions. each repetition has a drop down with 2 options. "P" and "R". My goal is that if all 6 Repetitions have R this will trigger another field called "status" to have the Letter "R", but if any of the 6 repetitions for chargeback have a "P". i want the Status field to show the Letter "P". I hope i'm making sense.

Thanks in advance.

Nestor

[comment]

What should the result be when SOME repetitions have "R", and others are empty?

[Nestor]

It should be "R"

Thanks

[comment]

OK, then it seems we are down to a single condition: one or more P's result in a P, otherwise R. If so, try:

Case ( IsEmpty ( FilterValues ( List ( RepeatingField ) ; "P" ) ) ; "R" ; "P" )