Summary Method Issue

Hi Community,

I'll try to put this in excel to describe my problem better. To explain the excel better, I have Region and Status title at page selctors, I have line items in column and Org L1 at Rows. Now Line item 1 already has a formula and its summary method is formula too. In line item 2, I want sum of only positives of line item 1. In line Item 2, I used formula - if line item 1 > 0 then line item else 0 but it needs to have summary method as formula for it to work, it doesn't give me required numbers at Bottom Levels if I use summary method as sum. Now since I use formula as summary method because Line item 1 top level has -80, I get line item 2 top level as 0, but I need 260(Sum of all positives from line item 1). Been trying to achieve this since days now. Any help would be appreciated

Thanks

Accepted answers

HimanshuRaj

@megha09 You need to create line item 2 staging and use the same formula that you used in line item 2 with summary method as formula and then in line item 2 - refer the line item 2 staging in the formula and set summary as sum.

That should fix it

Cheers!!

All comments

HimanshuRaj

That should fix it

Cheers!!

AkhilEmmanual

@megha09 you are doing it right. Same formula as you said If line item 1>0 then line item 1 else line item 2 and keep summary as sum. it will work and you will get sum as 260. You can refer the below screenshots

Screenshot 2023-06-07 6.45.44 PM.png

Screenshot 2023-06-07 6.49.22 PM.png

megha09

Hi @Himanshu1998 @AkhilEmmanual Thanks for quick response. I have tries these solutions already. the thing is when I select my region selector which is at L3 level to a L2 level item or even for status title, it still shows the same sum, if i use both of your suggested methods. Its because the summary method is sum it is summing it up at those level to. I don't want that. So lets say my Region selector is set to some item from Region L2, then my Line Item 1 numbers will change again. I ll need sum of positives from those numbers now.

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…