I need to put a page header on a form that shows the value of one virtual column from another table.
First of all, I tried it with a Show column. After that, I try with a virtual column, type Show, field “application formula” same as field “Context” but I am not successful.
Formula: CONCATENATE("Difference with Target: ",ANY(SELECT(OR[Difference with Target], AND([_THISROW].[ID OR]=[ID OR], [_THISROW].[Customer]=[Customer]))), “hs”)
“OR” is a slice
[Difference with Target] is an OR Virtual Column
The result is not an error, but does not show the value [Difference with Target] (type: duration)
I need help.
(Sorry my English)