Timeline for Can I sum the total value of 3 columns in a data extension?
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 21, 2019 at 15:11 | comment | added | Noor Alam | %%[set @contactId =[ContactId]]%% does this return a value? if not, then your lookup wont return results. can you try subscriberkey instead? | |
| Nov 20, 2019 at 13:14 | comment | added | Ben Owen | Hi Noor, we have other AMPscrits using lookups references on "ContactID' as that is what we have called the subscriber key field in the relevant data extensions and it works fine. I think my issue is I'm trying combine a SET function with a Lookup populating the reference, but i'm not sure how to get around this. | |
| Nov 19, 2019 at 12:06 | comment | added | Noor Alam | help.salesforce.com/… contactID is not there as a valid personalisation string, as mentioned previously I'd recommend subscriberKey | |
| Nov 19, 2019 at 10:23 | comment | added | Ben Owen | Hi Noor, yes when trying the snippet of AMP I added as an edit to the original question I got an error message when attempting to preview a test email, I'll revisit again with a fresh set of eyes but I went through every possible variant of field names I could to ensure it wasn't a simple syntax error. | |
| Nov 17, 2019 at 22:42 | comment | added | Noor Alam | as long as you have a a value to look up against in your other table i dont see why a lookup followed by ampscript addition wont work, you should probably use contact key/subscriber key rather than contactID which is a system identifier. When you say it doesn't work what do you mean? are you getting a error. Are you getting results returned from your lookup? | |
| Oct 31, 2019 at 10:59 | comment | added | Ben Owen | Have added info in the original question | |
| Oct 31, 2019 at 10:50 | comment | added | Ben Owen | Excellent, thanks! Can you think of a way this can combined with a Lookup in the case data is updated separately to contact data? | |
| Apr 9, 2019 at 16:24 | history | edited | Noor Alam | CC BY-SA 4.0 |
number format added
|
| Apr 9, 2019 at 16:15 | history | answered | Noor Alam | CC BY-SA 4.0 |