Summary error - Summary set to Formula

Hi Team,

I have a Boolean line item with a formula and when I set the Summary method to Formula I receive a 'Invalid combination of empty formula, and Summary set to Formula' error

I'm a bit lost because the line item has a formula and hence there should be no issue with the Summary method

Below is the both the error and Line Item

Any idea?

Thanks

Line Item.PNG

Accepted answers

JaredDolich

@MarkTurkenburg

Possibly you also have multiple versions that need a formula since you have all versions except actual set on that line item.

Make sure there's a formula associated with all versions.

I get the same error when I switched my scenario to all versions except for actual.

Invalid Version 001.png

All comments

ArunManickam

Can you set the Summary method for the line item 'DCA: OPEX71 Write Access' and try again.

Thanks

Arun

MarkTurkenburg_*8288

Hi @ArunManickam

I cannot change the summary method for the Line Item in the question or the referenced line item in the formula

I receive the same error each time

JaredDolich

@MarkTurkenburg

Possibly you also have multiple versions that need a formula since you have all versions except actual set on that line item.

Make sure there's a formula associated with all versions.

I get the same error when I switched my scenario to all versions except for actual.

Invalid Version 001.png

MarkTurkenburg_*8288

Thanks @JaredDolich

That makes perfect sense & is also quite annoying 🙂

Ok I need to remap my flow of data!

Mark

JaredDolich

@MarkTurkenburg

Yep, I know what you mean!

I've been down that road many times...

In fact, if I scroll back a year or two you'll probably see a post from me asking what I did wrong.

Always something new to earn about Anaplan!

Glad you got it solved.

Quick Links

Can you help?

Unanswered questions

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…
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…