Select to view content in your preferred language

Aggregation (Join) Calculations

498
2
02-08-2022 05:52 AM
dfinkbeinerTMEE
New Contributor II

I'm using a join calculation in a hidden field to to return values entered within a repeat to a heading for reference while water monitoring. I'm wondering if it's possible to limit the amount of records that are returned in this join.

For instance we could take 10 records within the repeat but I only need the previous 3 to join and display in the heading at any time.

 

Thanks for any help!

0 Kudos
2 Replies
DougBrowning
MVP Esteemed Contributor

Are the values about the same size? If  using substr(question, start, end).  Combine this with string-length and you could always peal off the last X chars from your join for display.  

Other idea is to use position and indexed-repeat functions to grab the last 3 values.

Hope that helps

0 Kudos
dfinkbeinerTMEE
New Contributor II

Thanks Doug!

I saw this on another thread and wasn't quite sure if it was what I was looking for. I'll give it a try and report back. 

0 Kudos