Need help to calculate the surivial yield of fishes shipped out from 2 tables and 2 columns

[TcT85]

Hi,

I'm trying to calculate the yield of our shipped orders to the customer and also count the yield of shipped fishes based on survival of the fishes We are sending out package deals of fishes and we have 2 package deals.

I have created a relation ship between these 2 tables with the colum package.

And I have manage to calculate the yield for each fish Package, but when I try to calculate the yield of fish Type i can't get the calculation correct.

Could someone please help and advise on how I should calculate the yield for each fish type?

Package	Type	Amount
Fish 1	Guppy	10
Fish 1	Betta	2
Fish 1	Goldfish	1
Fish 1	Angelfish	10
Fish 2	Guppy	4
Fish 2	Zebrafish	4
Fish 2	Tetra	4

Package	Order Serialnumber	Type	Amount	Fatality
Fish 1	100001	Guppy	1	Died during transport
Fish 1	100001	Guppy	1	Died after transport
Fish 1	100001	Betta	1	Died during transport
Fish1	100002			None
Fish1	100003			None
Fish1	100004			None
Fish1	100005			None
Fish 1	100006	Guppy	1	Died after transport
Fish 1	100006	Angel fish	1	Died after transport
Fish 2	200001	Guppy	1	Died during transport
Fish 2	200001	Zebrafish	1	Died after transport
Fish 2	200002	Guppy	1	Died during transport

[lbendlin]

I would change your data and data model slightly.

Then I would use TREATAS to project filters across the missing links.

From there you can modify as needed if you want other totals.

[TcT85]

Hi @lbendlin 

Never thought the Matrix could be used in this way, learned something new here.

But unfortuneatly it's not what I'am looking for.

I would like to count the total deaths for each fishtype and total fishtype shipped and divide the death with total shipped for each fish type.

[lbendlin]

Rearrange the matrix accordingly.