You’re offline. This is a read only version of the page.
12
Hello,
Is there a way to use a separate set value in a formula,
I have a table of products and there are columns with minutes each production step. I made a column ‘total production time’ with a fx formula that sums up these minute columns.
Now I want a new column that calculates the cost prices of that product using the ‘total production time’ multiplied by hourly cost price.
As this value may change over time, I would like to have it looked up in the formula.
Is there some way to do this? Store a variable or so? Or how to handle this?
Hi @Foxman_NL ,
How about modifying the value in the formula column directly?
Formula columns cannot reference values from another table unless another table has a relationship with this data source.
Best Regards,
Wearsky
Share
Report
All responses (
Answers (
