Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
I need to get field value from unrelated table by another field value in this table .
For example, we have table:
A B
----------
KPI1 55
KPI2 100
KPI3 55
KPI4 99
How can i get the value (col B) for KPI3? Is it possible?
FieldValue(A, 3) solution is not good, because there are duplicated values in B column.
I'd appreciate any help.
=Only({<A = {'KPI3'}>} B)
=Only({<A = {'KPI3'}>} B)
Use the Expression in Text Object =Only({<A = {'$(vSelect)'}>} B)
you have to create a variable and assign Getfieldselection(A)
Thank you, Jonathan, that's what helpfull!
Sorry, could explain how to check only result existense additionally?