Good afternoon,
I would like to place the total value of line item '%' in line item 'A'. In other words, I would like the amount 17,259 to appear in all the fields, but I haven't been able to do it. Could you tell me the formula to achieve it?
@CarlosRod
If the total is at the top level then use SELECT. If it's a parent level use LOOKUP. You'll need to use a system module for this.
A = %[LOOKUP: SYS01.Parent]
Hello, I am trying to understand how the ITEMLEVEL function works. I am reviewing the example shown in Anapedia (https://help.anaplan.com/itemlevel-756d1428-5f1d-4d79-8274-d075a1bd312f) but I do not understand how Result 1 is calculated. For example, why does California returns 0 but Texas 4? Also, Spain returns 3 but UK…
Hello, I am working for an implementation partner where both my current client and my company use SSO to log-in. When accessing models via the browser, my workaround to ensure that I'm not redirected to my company's SSO is by using incognito / private browsing. However, I'm unable to do this when signing into the Excel…
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.…
