Not able to apply SUM or LOOKUP

sharmagh

Hi,

I am trying to get the Proceeds amount for each Deal in Deals list, however not sure how can i get it, Kindly advise.

Here is the scenario:

Target Module List : Deals, LINE item = LTD proceeds

Source Module : List = Deals and Trans Type (Proceeds as one of the TT), Line Item = Amount

Thank you!

Accepted answers

Akhtar.shahbaz

Hi @sharmagh

1. Create one system module to do the mapping with TT

2, Source Module:

3. Target Module:

Hope this helps!

Thanks

Akhtar

All comments

Misbah

@sharmagh

If you are trying to get the deal value at an aggregated Trans Type Level then make sure you have Top Level set as “All” in Trans Type List and simply point to the source line item.’

Formula in Target Module Line item = Source Module. Amount

Thanks,

Misbah

sharmagh

But then i'll get the value of all the trans type at aggregated level and not for only Proceeds for each deal.

sharmagh

@Misbah

But then i'll get the value of all the trans type at aggregated level and not for only Proceeds for each deal.

Misbah

@sharmagh

You have got Trans Type and Deals in your source module. Now when you say Proceeds for each deal-what do you mean by that?

sharmagh

@Misbah

Proceed is one of the Trans Type there are few more TTs

prabhu

Hi @sharmagh,

I am not 100% good in Finance Domain, but i created a scenario which might be helping you.

I Created another List which contains only Proceeds.

Here is my Transaction Type and Proceeds List.

My Source Module

Blue Print of My Source Module

I Created a System Module to calculate the Sum of Proceeds on each Deals.

Here is My Target Module, which will get the data based on your selection.

VIGNESH.M

Hi @sharmagh ,

Try this,

#1. Create a system module to identify the Proceeds Trans from the Transactions list.

#2. Add a line item in the source module as shown below to extract only the proceeds amount.

#3. Use the new line item as your source in the target module.

In this way, you can bring only the proceeds transaction amount.

Regards,

Vignesh M

sharmagh

@VIGNESH.M

Hi,

It is closer to what i am looking for however, in my target module i need amounts for each TT in separate columns, for this i am trying to apply lookup. like #2 module (source) and #3 module is the target have 3 separate columns for all the three TTs and i think boolean in this scenario is not a good idea.

Akhtar.shahbaz

Hi @sharmagh

If possible can you please share some screenshot of your source and Target module?

it would be good for us to understand and we will provide the solution accordingly.

Thanks

Akhtar

sharmagh

@VIGNESH.M

Hi,

Here is the actual picture:

Source Module:

Target Module:

Thanks!

sharmagh

@Akhtar.shahbaz

Here is the screen shots:

Source Module:

Target Module:

Thanks!

sharmagh

I got the solution i need to use Select function.

Thank you so much for putting time and effort

Akhtar.shahbaz

Hi @sharmagh

1. Create one system module to do the mapping with TT

2, Source Module:

3. Target Module:

Hope this helps!

Thanks

Akhtar

Akhtar.shahbaz

Hi @sharmagh

As per the best practice,don't use SELECT function, Just create one system module as i have shown in the example and try to lookup the item. Always try to avoid hard coding by using select function.

Hope this helps

Thanks

Akhtar

sharmagh

Completely Make Sense thank you!

sharmagh

Just for better understanding, in case if i changed the Headers then i'll not get the values unless i update the Mapping right?

Akhtar.shahbaz

Hi @sharmagh

You mean to say Target module header,Even if you changed the header of the Target module or System module doesn't matter.

Target Module: I have changed the name

Lets say even I have changed name of the system module line item, it will not impact.

Hope this helps!

Thanks

Akhtar

sharmagh

One last question, how did you created the SYS module? because when i am trying the same as you mentioned it not working here.
I took All TT (List) as dimension in the rows and added a line item Mapping and formatted it with TT (list) so that I can choose through Drop down.

kindly advise.

Akhtar.shahbaz

Hi @sharmagh

You don't need any dimension in the system module.Create list formatted line item only:

Thanks

Akhtar

sharmagh

Sys M.PNG Screen shot for your ref:

sharmagh

Thanks!

roundcubeeight

i was facing same issue, but its solved now

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
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…