Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the meaning of Only and numbers in the below formula?
=Only({<No={26}>} [$(=vDataLanguage)])
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
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.
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