SOLVED
Formula
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
jlfromm
8 - Asteroid
‎10-17-2022
09:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a set of data that have the same Recip ID for month 1, 2, 3. I want to create a formula that will just select the newest inform from that recip if.
Example If Recp id -001A has inform for month a 1 and 2 then i want the infor on the from month 2
IF Recp ID - 002B has information for month 1, 2, and 3 then I want information on month 3
Solved! Go to Solution.
Labels:
- Labels:
- Interface Tools
2 REPLIES 2
Felipe_Ribeir0
16 - Nebula
‎10-17-2022
09:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @jlfromm
It would be better to see the exact table for input/output.
If your input is like this:
Then the attached workflow will do the job.
If it is not, please paste/attach your input/expected output here.
‎10-17-2022
11:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you this will work