Unable to Change the Summary of Line Item from Sum to Formula: Time, Sum

Hello,

I'm getting an error when changing a line item's summary from "Sum to Formula: Time, Sum":

"Invalid combination for line item 'Sales' of summary method 'Formula' with formula using LOOKUP and/or SUM (or other summary function)"

The formula of the line item does indeed have a Sum function, and I'm getting it from another module which has a "Formula: Time, Sum" summary. I would like to be able to get the same amount as that module summed by industry for example:

SourceModule.Sales[SUM: Industry]

But because they have the different summary, I'm not able to get the same results.

Thanks in advance for any input you can give.

Thanks,

Jonathan

Accepted answers

jspascual

Hi everyone,

Thanks for your responses.

I was able to use a property on the list I want to get the values from using a Sum function, without the need for changing the formula summary.

Thanks!

Jonathan

All comments

Misbah

@jspascual

Is there a Lookup or Select statement in your Target line item? If so, Anaplan won’t allow you to change the summary settings to from Sum to Formula.

Post a snapshot that will help

Misbah

anirudh

Hi Jonathan,

This is one of my pet peeves with Anaplan. There is no way to apply a SUM or LOOKUP on the parent list items through a child line item formula summary

You will have to create separate modules for each parent list and display them separately. So in your case, keep the summary as Sum in your current line item. Create a module for each parent level. Then simply refer to the current line item for each parent module

Hope that helps

Regards,
Anirudh

einas.ibrahim

Hi @jspascual

What others said about using the summary Formula with line items that have SUM or LOOKUP in the formula is not allowed by Anaplan.
I am a bit confused though if you are reading the value of the line item in question from a different Line item, then why do you need to sum by a formula?

Maybe as @Misbah said, it'll be clearer if you provide a screenshot or more details.

jspascual

Hi everyone,

Thanks for your responses.

I was able to use a property on the list I want to get the values from using a Sum function, without the need for changing the formula summary.

Thanks!

Jonathan

einas.ibrahim

Hi @jspascual

I'm glad you found a solution. Just a word of advice; you should avoid using list properties and instead use system modules to hold the properties for the list.
There are a few instances where one has to use list properties such as with numbered lists or dependant list... however, for best practice we don't rely on list properties.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…