Variable?

(0) Share

Report

Posted on by Foxman_NL

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?

Categories:

Microsoft Dataverse

All responses (1)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Re: Variable?

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