Get a total value on other line item

Hi,

Can you help me with the next item. I need get the total value of the line item "%" and put in the line item "Pond".

in the line item "Pond" is using a LOOKUP but a cant see any value.

Accepted answers

Hi @CarlosRod,
If you only need total value of your hierarchy (I assume your dimensions is called "Goe"), then you can do it by either:
1. Changing formula to just reference "%", end then removing your Geo dimensions from "Applies To" (Anaplan will automatically pick up total sum).
2. You can use formula "%[SELECT:Geo.All Regions]".
FYI, I prefer 1st solution, as it takes less space.

All comments

M.Kierepka

CarlosRod

Thank you,

I use the select and its working.

Quick Links

Can you help?

Unanswered questions

How do I determine why Anaplan API login fails intermittently ?
Hello, My interface uses basic authentication to log in to Anaplan. The login process has been failing intermittently for about a week. How can I identify the root cause of these Anaplan API login failures? Username and password are correct. The account is not locked or expired. Thanks, Jorge Palma
Anaplan XL license issue
Hello , I recently started Anaplan XL course , added XL however not able to add license How to ad license
Error while uploading ADO screenshots
Hello Anaplan Community, I'm facing an issue while uploading ADO screenshots, crosschecked my file size and naming conventions they are correct as mentioned in the lesson. Anyone faced the same issue? Pls let me know how if any solution to this problem. Thank you.