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
Solved! Go to Solution.
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
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
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.
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
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.