I have a column in the warehouse table
Column name "Balance"
In the inventory table there is a column named "Total"
I want to show the value of the "Balance" column in the "Total" column
Does the Inventory table reference the Warehouse table? If so, try an expression like the following in the [Total] column's App formula property:
[Warehouse ID].[Balance]
Keep in mind that if [Total] is a data source column and not a virtual column, it will only update for a given row when that row is edited.
If you explain what need you're trying to fulfill, someone may have a suggestion for how to accomplish it differently.
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |