I have to calculate rows and data from different table

Question

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:

FundamountpurchasereturnbuyA123456489785B456500800400C48956487450Total 1068152013761635

Percentage dataset:

FundamountpurchasereturnBuyABC0.50.80.90.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

FundamountpurchasereturnbuyFinal228400720320

davidskaife · Answer

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!

Rows and Data Calc.yxmd

JamesCharnley · Answer

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.

Fund%Finals.yxmd

Sshasnk · Answer

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