Formula questions

Hi,

I'm attempting to write a formula to pull in the percentage amounts of a line item in a different model in accordance to a certain vintage year. I'm trying to use either the LOOKUP or SELECT function but getting a error. Please advise.

'R01 Inputs'.Funding Scaler[LOOKUP:Vintage]

Thank you

Accepted answers

DaanishSoomar

Hey @neg177,

Happy to help! LOOKUP formulas are generally better from a PLANS perspective.

Let's see what we can do to help resolve the formula issue. Are you able to provide the following information:

1) A screenshot of your Target Module? Also a screenshot of your blueprint view?

2) A screenshot of your Source Module? Also a screenshot of this blueprint view?

3) If you can also paste here what formulas you have tried, and a screenshot of the error message that would be great!

Assuming this is related to a dimension mismatch issue. Happy to take a look further and explore possible solutions!

neg177

Hi,

Thank you for your quick response. I have attached the requested. And the formula below. I'm trying to get the Scalar Funding Line Item of percentages to go into the Source Module in accordance to Vintage year and not months.

Question_01_101738.JPG

Question_02_101738.JPG

Question_03_101738.JPG

Question_04_101738.JPG

DaanishSoomar

Thanks for the reply @neg177, I think I understood most of that. If I follow correctly, you are trying objective is to take the FY21 Year - Scaler Percentage from the source and show that number in the target across all the months?

I would reccommend using the YEARVALUE function.

So your formula would be YEARVALUE('R01 Inputs'.Funding Scaler), you don't need to do a LOOKUP if this is the case as the dimensionality is the same across both source and targets, therefore no cross dimensional functions required.

All comments

DaanishSoomar

Hey @neg177,

Happy to help! LOOKUP formulas are generally better from a PLANS perspective.

Let's see what we can do to help resolve the formula issue. Are you able to provide the following information:

1) A screenshot of your Target Module? Also a screenshot of your blueprint view?

2) A screenshot of your Source Module? Also a screenshot of this blueprint view?

3) If you can also paste here what formulas you have tried, and a screenshot of the error message that would be great!

Assuming this is related to a dimension mismatch issue. Happy to take a look further and explore possible solutions!

neg177

Hi,

Question_01_101738.JPG

Question_02_101738.JPG

Question_03_101738.JPG

Question_04_101738.JPG

DaanishSoomar

I would reccommend using the YEARVALUE function.

CommunityMember126793

@neg177 , since you only want to copy the Year values from the source module so you can keep the target module's "Time Range" as Year and simply refer the source module line item... pasting some screen prints if it will help to understand the say:

1. R01 module has 1 line item with month "Time Scale" (as you may not afford to change the Time Scale in the existing model structure).... Data Type = Number (percentage)

i am simply using "Average" in the Summary.. And that's what I need to copy in target module..

2. Target module: If only Year to be maintained so changed the "Time Scale" to Year.

Feel free to let us know if anything else is require here..

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385