Anaplan on Anaplan: User Groups Live!

Certified Master Anaplanner

Re: Ask Me Anything!

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

 

Message 31 of 38
Certified Master Anaplanner

Re: Ask Me Anything!

Or you'll set @DavidSmith on us!

Message 32 of 38
Certified Master Anaplanner

Re: Ask Me Anything!

Do you foresee the addition of a "Now" function being added to Anaplan?

Message 33 of 38
Certified Master Anaplanner

Re: Ask Me Anything!

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?

Message 34 of 38
New Contributor

Re: Ask Me Anything!

Which formula can I use to determine if a value exists in a property of a list.

Example:

I have a list Emp, which has a Email property. I need to find if "abc@a.com" exists.

Message 35 of 38
Occasional Contributor

Re: Ask Me Anything!

>> Which formula can I use to determine if a value exists in a property of a list.

>> Example:

>> I have a list Emp, which has a Email property. I need to find if "abc@a.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

Message 36 of 38
Occasional Contributor

Re: Ask Me Anything!

Hi @abinchen,

 

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.

2019-03-22_11-53-07.png

 

2019-03-22_11-54-38.png

Message 37 of 38
Highlighted
Community Manager

Re: Ask Me Anything!

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!

Message 38 of 38