SELECT - two attributes

samdal · 2023-09-15T08:55:53+00:00

There was an error rendering this rich post.

I try to write a function that selects both a specific version and a specific level in the hierarchy from a list. I know how to use the SELECT function individually on each of those selections: 1) Sales module.Gross sales [SELECT: VERSIONS.Actual] and 2) Sales module.Gross sales [SELECT:Product.Nuts]. How do I write the formula to combine those two selects?

Accepted answers

Misbah

@samdal

Sales module.Gross sales[SELECT: Versions.Actual, SELECT: Product.Nuts]

Note that if Product list is a Production data, you may need to use LOOKUP instead

Thanks,

Misbah

Miz Logix

samdal

Thanks!

All comments

Misbah

@samdal

Sales module.Gross sales[SELECT: Versions.Actual, SELECT: Product.Nuts]

Note that if Product list is a Production data, you may need to use LOOKUP instead

Thanks,

Misbah

Miz Logix

samdal

Thanks!

andrewtye

And of course if you are using a Lookup then would have that as two separate line items. One for the select and then one doing the lookup.

Quick Links

Can you help?

Unanswered questions

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…