Information for a Line Item Disappears when in Top Level

Hello,

Good day!

I hope every one is having a nice day.

I would like to ask for any information that may help in troubleshooting this issue.

I have a line item in a module called, "Credit Account". I have it in formula which basically says: If the Company is 'A' then use account number '12345', ELSE, use '67890'. This is working fine, and the accounts are populated in the line item BUT only on the lower levels of the company hierarchy. If I go to the Topmost Level/ the Conso Level, it is not showing up -- it's just blank. The information must show up at the top level as per the requirement -- an output to a csv/excel.

What am I missing?

Thanks so much!

Jonathan

Accepted answers

andre.lie

Hi @jspascual

If your line item is text, by default the Summary method will be set to None. You can show the text at Parent level by changing it to First non-blank or Last non-blank.

Regards,

Andre

usman.zia

Hi @jspascual

As @andre.lie mentions you need to change the summary method to allow the formula to show the value at the higher level.

But you need to consider a few points:

1. Does your hierarchy have multiple items below and is bringing the last or first the correct code you want to see? (as in @andre.lie example he has many cities and if they all had a code which code would you want to see?)

2. It may be the case that you only have one item today but in the future this may change you may have two items and this can cause errors in the future (has happened to me!). How do you deal with this?

3. Do I need to have another formula at the top level to account for this and change the formula to bring this in to avoid the issue (where a subsidary view can help).

Also I notice in your formula you have hard coded codes is this just for the result of the example your explaining or it is actually hard coded? Worth considering is this sustainable for the future?

I hope this helps!

Thanks,

Usman

All comments

andre.lie

Hi @jspascual

If your line item is text, by default the Summary method will be set to None. You can show the text at Parent level by changing it to First non-blank or Last non-blank.

Regards,

Andre

usman.zia

Hi @jspascual

As @andre.lie mentions you need to change the summary method to allow the formula to show the value at the higher level.

But you need to consider a few points:

3. Do I need to have another formula at the top level to account for this and change the formula to bring this in to avoid the issue (where a subsidary view can help).

Also I notice in your formula you have hard coded codes is this just for the result of the example your explaining or it is actually hard coded? Worth considering is this sustainable for the future?

I hope this helps!

Thanks,

Usman

andre.lie

Hi @usman.zia ,

I definitely agree with your points.

Regards,
Andre

jspascual

Thanks for all of your input.

Thanks!

Jonathan

jspascual

Thanks, @andre.lie.

I do have a follow up question on this.

This works when the other companies have data on them.

However, when only company 'A' has data for a given period, the top level should only show the account specific for 'A' company.

Is it possible?

Thanks,

Jonathan

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…