Here are some ways to reduce sparcity:
1. Turn off un-needed summaries
2. Use List Subsets
3. Use time ranges
4. Setup a single conetanated list to help consolidate multiple dimensions
5. Keep data loads flat
6. Don't over dimensionalize modules
What are some of the best ways you have found to indicate the data displayed on dashboards is still moving and not finalized yet? Are there any suggested methods other than creating a module that acts as a tracker and publishing it to the top of each dashboard that can visually call out that the final numbers are not ready yet?
Which formula can I use to determine if a value exists in a property of a list.
I have a list Emp, which has a Email property. I need to find if "firstname.lastname@example.org" exists.
>> Which formula can I use to determine if a value exists in a property of a list.
>> I have a list Emp, which has a Email property. I need to find if "email@example.com" exists.
Hi abinchen, you can use [lookup:, textlist:] combination
for example you have Emp list with two properties: Emai and One (which has number format and always equal to 1)
In your module you have EmailToSearch line item, which contains email to search
Formula should look like: IF Emp.One[lookup:EmailToSearch,textlist:Emp.Emai]>0 THEN TRUE ELSE FALSE
There are a few ways to accomplish your request. For ease of reference, I created a module and provided some examples. My guess is you probably tried to use the FIND function. The FIND function works with text formatted strings. The "@" symbol isn't a text formatted string within the Text Formatted Property (Text: Email). The text characters for the "@" symbol is really "%40".
In Option 1, I've shown you a drawn out way to accomplish so you can see the step-by-step process. The 'Conditional Logic' line item shows you how to do it in one step.
In Option 2, I've shown how to do it with the COMPARE functionality. In the 'Compare' line item, it shows a "-1" where the Email Address doesn't equal the 'Domain' line item.
Option 3 represents loading the Email Address as a Text:General formatted item, converting it to a Text: Email formatted item for different usage, and then determining what email is invalid by using the Text:General formatted line item.
I hope this helps you determine the best way to accomplish for your particular example.
The AMA has now ended. We hope you enjoyed the live session. If you have additional questions, please consider posting your questions in the forums section where the Community will be happy to help!