Summary Value - Top level not defined in list

Hi,

I have requirement in which I need the Total Cash value - which is kind of top level but the top level is not defined in the list configuration so I have tried my best to get the Total cash value for the "Sweep In" checks but unable to get the value without using the select statement as I have to make this list as production list

So I would like to know how to get the Total cash value without using the select statement. Screenshot attached for Reference

So I want to get the Total cash value and subtract that with Debt Bank value

Appreciate your help

Regards,

Riyaz Pasha

Accepted answers

All comments

KirillKuznetsov

@riyazpasha

Summary function works as a sum of the leaf elemtnts of the list. To subtract something you have to select one of two options:

- ask users to enter negative value. Then automatic sum will work correctly, like: 2 + -1 = 1

- add a calculation line item wich will multiply by -1 those list elements which you want to be negative and then use the summary from this line item as a calculated value. (for this you would have to make more additional steps such as usin Ratio summary function). Let me know if you want to go this way - I will explain.

The second method is a bit more complicated than the first one and I think you should use it only if you can't make user enter the minus sign.

riyazpasha

Hi @KirillKuznetsov ,

Thanks for the prompt response,

The users cannot enter negative value as those will be the bank balances.

So I would like to go with the second approach. Basically I need the Total cash value for that day/month and remove the Debt value(which means subtract saving accounts value) to compare the other line items

Regards,

Riyaz Pasha

KirillKuznetsov

Hi @riyazpasha

Please add two line items: calc and '1'

1) in calc put a formula: threshold limit * IF Savings Account THEN -1 ELSE 1

2) in '1' just = 1 (summary method: Max)

3) select threshold limit and change Summary method to Ratio. with the following settings:

riyazpasha

Hi @KirillKuznetsov ,

Thanks for the solution.

But Can I replace the select part with some other alternative solution as I have to show the user from which Bank they can sweep in from and Sweep out to. So in order for that I was getting the value of Amount Available for total Cash subtract with Debt Bank which will give me the other banks value where I have to check if that greater than the Amount Required so I want the select to be replaced with some alternative solution as I need to make the Bank list a Production list

Thank you,

Regards,

Riyaz Pasha

KirillKuznetsov

@riyazpasha

You can. General rule is that you avoid using select function anywhere except Top level elements of the lists and versions. Instead you can use LOOKUP. You can make a system module without any dimension and place any list formatted line item here for reference via lookup. For example, "Total Cash" line item with Total cash element selected manually in it.

Arnab116

Hi Riyaz @riyazpasha ,

1. Create 2 line items Total Cash & Debt in the same module without any dimension.

2. Create a System module with 2 line items Total Cash 1 & Debt 1 having BANK List format and without any dimension. Manually Map Total Cash & Debt.

3. Go to the source module and formulate:

Total Cash - Treshhold[LOOKUP: System Test.'Total Cash 1']

Debt - Treshhold[LOOKUP: System Test.'Debt 1']

Refer the screen shots for more undersanding.

Hope this helps!

Thanks,

Arnab

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…
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…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…