Calculated field between 2 tables

Kynesl — Fri, 15 Feb 2019 15:52:43 GMT

Hi All,

I am looking to creating the total sales amount from two separate tables, each with information required.

table 1

table 2

I need to multiply the 2016 SP by the Sales Qty, but having a struggle calculating these.

All suggestions would be greatly appreciated.

Regards,

Kyne

Re: Calculated field between 2 tables

marksouzacosta — Fri, 15 Feb 2019 16:06:16 GMT

Hi Kyne,

Can you share a picture of your Data Model and your Load Script?

Regards,

Mark Costa