Referencing a line item that has formula summary method, not displaying correct number

ShakirHabib · 2024-02-02T10:03:19+00:00

There was an error rendering this rich post.

ShakirHabib

Hello,

In the example image, I am referencing a line item "TV Programming (Final)" in another module using an If statement

IF XXXX

THEN XXXX.'TV Programming (Final)'

ELSE 0

However, it isn't pulling 4,063,964,538 as expected. I know its an issue with the summary method being set to formula because other line items are referenced the same way in the target module using sum, and the number will be referenced properly. I can't use sum though, as this will show an incorrect value. Is there something else wrong?

Thanks

Accepted answers

Dikshant

@ShakirHabib - I hope you are referring to this formula. If you enable the summary of this Include in cost book forecast? line item and then enable the summary of the main line item, the formula should work. All line items you're using should have a summary enabled in order to get the correct results.

Can you please share the screenshots without hiding the final numbers. it will help us understand the current behavior.

All comments

Dikshant

@ShakirHabib - What's wrong with setting up summary as SUM if, at the end, you want to just sum up the child members? IF ELSE with summary as formula will do the same calculation at parent level and will not give the summed up values. Is there a specific reason you are trying FORMULA?

ShakirHabib

@Dikshant Hey - I'm using formula because the line item contains a multiplication calc, and if I change the line item summary to sum for that line, then the product is incorrect. I've included images of the formula for tv programming final and the tv programming lookup line that is used for the tv programming final line. Formula was used because "TV programming (Final)" is "TV programming (lookup)" * "tenure". So "TV Programming (Final)" is using formula and "TV Programming" that is trying to reference it is using sum

MarkWarren

We can't help without seeing the full context and what the IF statement is doing.
What value do you get in the target module without the IF condition, just a reference?

ShakirHabib

Hi @MarkWarren apologies for the lack of context, here is the full if statement of the line item that is causing issues. If I remove the IF statement and reference 'TV Programming (Final)', there is no change and I still get 2,007,545,053.

If I change the 'TV Programming (Final)' summary method to sum or I reference a different line that uses sum, then the same figure will show in the target module as expected - but if I change 'TV Programming (Final)' to sum, it will give an incorrect value (maybe because there is a multiplication in the formula) so I want to use formula summary method.

EDIT: I changed the summary method to formula and removed the IF statement and it works now. But the IF statement should be included, is there any way to use IF statement with formula summary? Thanks

Dikshant

Can you please share the screenshots without hiding the final numbers. it will help us understand the current behavior.

unknown

This content has been removed.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…