I want to calculate the LineTurnover (formula field) with a variable (number) from another DataSet.
So basically this is what I want:
from_dataset(“RegelOmzetID”, price, id: "productid) * “amount”
So I want to multiply the price of the productID from Dataset: “RegelOmzetID” times the “amount” what is in my current dataset. ProductID is the FK from the other DataSet BTW.
Don’t know if this is even possible to do. Can someone help me?
Project link: https://mockaroo.com/695634e0