I would like to calculate a new dimension with data from two actual dimensions in two different tables.
In my LoadTable(.csv file from a web-address that holds historic stock information) I have several dimensions where I would like to multiply the latest value of my dimension "Close" (Dimension date in LoadTable = Today). Thereafter I would like to multiply with "CurrentHoldings" in my table Stocks to get the ActualValue.
This operation should be looped for all my stocks in my table Stocks.
How can this script look like? Or can it be done in any sheet object?
