Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a column the following structure:
MasterContactID | ContactID | Index | Description |
90 | 90 | 1 | |
90 | 90 | 2 | |
90 | 90 | 3 | |
90 | 90 | 4 | Outbound |
90 | 90 | 5 | Outbound |
90 | 90 | 6 | Inbound |
90 | 90 | 7 | Inbound |
90 | 91 | 1 | |
90 | 91 | 2 | Inbound |
90 | 91 | 3 | Outbound |
90 | 91 | 4 | Outbound |
90 | 91 | 5 | Outbound |
What I am trying to get is:
"The 1st non-empty Description, for the smallest ContactID of the current MasterContactID"
So this record would be :
90 | 90 | 4 | Outbound |
I am trying to get this done with this Set analysis:
FirstSortedValue( {$<
ContactID = {"=Min(ContactID )"},
Description-={""}
>} distinct Description, ContactID )
But is not working, it is not filtering ContactID with ContactID = {"=Min(ContactID )"}.
Any Suggestions?
Thanks in advance four your time.
-Ed
A few minor changes seem to fix it if I've understood the question:
firstsortedvalue({<ContactID={'$(=min(ContactID))'},Description-={''}>} Description, Index)
Edit: Following up for the same reason as Michael, I've assumed you are selecting or otherwise in the context of a specific MasterContactID. That's why there's no inclusion of it above. I don't know if this is the case.
Ed, try
ContactID ={"$(=Min(ContactID))"}
Edit:
Nope, I'm wrong, you have to get min within master contact id, which is probably closer to this:
min(total<MasterContactID> ContactID)
A few minor changes seem to fix it if I've understood the question:
firstsortedvalue({<ContactID={'$(=min(ContactID))'},Description-={''}>} Description, Index)
Edit: Following up for the same reason as Michael, I've assumed you are selecting or otherwise in the context of a specific MasterContactID. That's why there's no inclusion of it above. I don't know if this is the case.
Thank you very much, the function did work, it seems i was calling the inner Min() wrongly.
Regards
EDIT: By the way, you assumption was correct I was selecting a MasterContactID. 🙂