Formula help on finding a % of a Calculated LI

Hi,

I'm trying to create a formula where it will create a % based on taking my States List parent by each individual state.

The formula I have so far is Total Collections / Total Collections[SELECT: State.North America] . I feel like this is correct but my percentages are not looking right. Please advise.

want to take this amount

and divide it by the total States List amount

Thank you

Accepted answers

All comments

ShubhamCh

Hi @neg177

The formula is incorrect because it is only referring to North America total, which becomes wrong when the parent is other than NA.

Right approach would be

Total Collections/ Total Collections[Lookup:SYS Module.Parent]

I assume you have one SYS module for your child states where you've defined parents. If that's not the case, add one line item - "Parent" (Parent List Formatted), formula - Parent(Item(your current child state list name))

Use this line item as your lookup mapping.

It'll calculate as you want it to.

Thanks!

-Shubham

neg177

I'm not quit sure if I'm doing what you said correctly. Can you please check?

The formula for the Total Collections % doesnt work.

Thank you

andrewtye

Hi @neg177

Not sure if this is still hanging about but couple of things.

1. Don't use "SELECT:" when referencing list items (unless this happens to be the very top-level of it), best practice is to have a look-up module and reference that as @ShubhamCh points out.

2. The summary setting for this should be formula - now using lookup and formula clearly won't work so you'll need in intermediate line item that pulls back the relevant number using that parent line to look-up against (which btw should be in a property module - again best practice)

Hope that helps!

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…