I have to calculate rows and data from different table

[Sshasnk]

I have 2 datasets one is the fund dataset and another one is the percentage dataset I have to use both and calculate the value.

Fund Dataset:

Fund	amount	purchase	return	buy
A	123	456	489	785
B	456	500	800	400
C	489	564	87	450
Total	1068	1520	1376	1635

Percentage dataset: 

Fund	amount	purchase	return	Buy
ABC	0.5	0.8	0.9	0.8

Now, I have calculated the (Total amount - C - A) * ABC = (1068 - 489 - 123)*0.5 for all the columns

The above formula is used for Amount/Purchase/Return/Buy

Fund	amount	purchase	return	buy
Final	228	400	720	320

[JamesCharnley]

Hi @Sshasnk,

It's going to be quite hard for somebody to replicate a workflow for this that's dynamic to your actual data without a few more details, unless your data is very consistent to this structure. For example, is there always three funds and it's Total-C-B every time? Or can there be more? It'll be much easier if it's the former.

[Sshasnk]

@JamesCharnley The formula won't change at all (total -C-B)* ABC (percentage dataset) and So as the structure 

[JamesCharnley]

OK thanks @Sshasnk, one more thing: The formula is written as (Total amount - C - B) * ABC but your example references (1068 - 489 - 123)*0.5, where 123 is the value for A not B. Which one is correct?

[Sshasnk]

@JamesCharnley Oops, (Total amount - C - A) * ABC Instead of B it should be A

[JamesCharnley]

OK @Sshasnk  something like this should work. The Fund is tokenized so it can be joined to the correct rows (assuming the % fund is made up of the names, otherwise we'll need something else), and using a multi-row to reference cells from another row:

You could do it in less tools but this should be the easiest to get your head around I think.

[DavidSkaife]

Hi @Sshasnk 

If your data structure is always like this, then your calculation doesn't need to be so complicated, you can just do B * ABC instead.

Also, you say Total - C - B yet you reference the value from A, and the final values all work with A, not B

I've attached a workflow that should give you what you need,its a bit long winded but it works!