I have 4 decimal columns that will change value IF the virtual columns are <> 0.000
(formula of virtuaL columns P1 to P4:
IF(
IN("P1", SELECT(Additional Perimeter[Which Wall/s?], [Room Key] = [_THISROW].[Room Key])),
ANY(
SELECT(Additional Perimeter[Total Additional Perimeter], [Room Key] = [_THISROW].[Room Key])
),
0.000))
I tried automation but not working, not copying the value of virtual columns. I cannot set app formula to my physical columns since I have to make it editable if [Additional] = "YES" (setting app formula with editable_if is also not working)
First.. if the column type for [Additional] is Y/N, try [Additional]=TRUE and see if that helps.
User | Count |
---|---|
17 | |
14 | |
10 | |
7 | |
4 |