Get latest inspection values from repeat

[SumukhRamesh]

Hello,

I'm looking to extract the latest values for valve_status and loto_status fields (that exist in repeats) and store it outside of repeats in last_asset_condition and last_lockout_tagout_condition fields respectively. I've taken the approach of first calculating the count of number of related records and then getting the field values based on the latest count and asset name. Unfortunately the two filters dont seem to work together. Any ideas on how to fix this?

[abureaux]

From your description, sounds like you just want "the latest item from the active survey repeat"? If that is the case, you don't need all those fancy-pants calculates.

Just use an indexed repeat and pull data that way: