What is the meaning of Only and numbers?

[#1]

What is the meaning of Only and numbers in the below formula?

=Only({<No={26}>} [$(=vDataLanguage)])

[alexandros17]

Only({<No={26}>} [$(=vDataLanguage)])

If there exists ONLY ONE instance of vDataLanguage (Must be an expression I think) corresponding to the number No = 26 then the expression returns the value

[manojkvrajan]

In addition, ONLY will return the value only if  $(=vDataLanguage) returns a distinct value. In other words, ONLY cannot return any value if No={26} has more than one row associated to it.

[Peter_Cammaert]

If you apply the previous explanations to your example, it means that you force Message nr. 26 to appear in a chosen language (vDataLanguage) in a text box. Imagine that vDataLanguage contains value 'EN', and you have an island table like this:

No,  FR, EN, DE

:

25, Bilan, Balance, Bilanz

26, Accomptes, Accounts, Rechnungen

27, Bénéfice, Profit, Gewinn

:

Then a text box that carries your example expression will show 'Accounts'.

Best,

Peter