How do I have a forumla calculate data to a specific dimension member?

iosman123

Hello,

How can I have a formula calculate data for a specific member of a dimension and place a 0 for the others?

500error

thanks

iosman

Accepted answers

All comments

kavinkumar

@iosman123

Yes, you can do that only with Versions and you have to use a line item subset. Go to blue print and make use of Formula scope.

For more information on this, please follow this link:

https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Add_Version_Formula.htm

Hope this helps,

Kavin.

DavidSmith

Simple
Create a module dimensioned by the dimension you want to logic on (eg dimension logic)
Add a boolean line item(eg logic1) and tick the applicable dimension member(s)
Now in your target module refer to that line item in your logic:
IF dimension logic.logic1 THEN x ELSE y

This is much better than a SELECT statement because it is flexible and allows for multiple members to follow the same logic if needed. It can also be expanded for 2+ types of logic

David

Quick Links

Can you help?

Unanswered questions

one or multiple models
Does anyone have any documentation on the trade-offs of having 1 model for all components of planning (service revenue, product revenue, labour planning), vs multiple models 1 for each and a consolidation model to tie it all together?
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…