'Formula' sum for 'list'-formatted line item

Hi all,

This article ( https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Summary_Methods.html ) claims that list formatted line items can have 'formula' as summary type.

screenshot.25.png

In reality it does not work for me. If I try to set summary type to formula - system tells me to enter formula first. I do that and try again:

screenshot.26.png

I get the error.

The logic behind this formula is very simple. I have 2 lists with identical items, one of them is flat, with no parents. I want this formulat to take an item name from multilevel list and find corresponding element in second list (flat one). This formula makes sense for both leaf level and aggregated level items, but I can't get it to work.

Any ideas are welcome.

Accepted answers

harish_bk

Hi YS

Since the parent list is coming from different List (The one selected as parent in configuration) you will have this issue.

If you could give us the requirement we can see how we can help you with a workaround.

All comments

PavanKumar

Hi,

Change the lineitem format to "Account Hierarchy Deleveled". It will work as expected.

Hope this helps

Regards,

Pavan

YS_*12825

That is how it was from the very beginning

screenshot.27.png

PavanKumar

If the dimension is "Account Hierarchy" and the lineitem format is "Account Hierarchy Deleveled", then the formula "FINDITEM(Account Hierarchy Deleveled, NAME(ITEM(Account Hierarchy)))" should work fine.

Regards,

Pavan

YS_*12825

Yes it should. And it does. But only for leaf level elements. As soon as I switch sum method to 'formula', I get error

YS_*12825

This is how it works screenshot.29.png

I need it to work on aggregates as well

harish_bk

Hi YS

Since the parent list is coming from different List (The one selected as parent in configuration) you will have this issue.

If you could give us the requirement we can see how we can help you with a workaround.

YS_*12825

Thanks!

This is most probably the right answer. If it's not - I'll post an update.

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Importing from Data Hub: Incorrect or Missing Mappings in Target Model
When importing data from a Data Hub to another model, I'm seeing values in the target model that don't exist in the source. For example, seller assignments are being tagged with subregions that aren't present in the source data - some assignments are missing expected tags, while others are mapped to seemingly random…
ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.