Discussion Board for collaboration on QlikView Scripting.
what is there in REF Build field ? is it a static value?
What is the error ?
What is the result and what do you except ?
To have the best effort from the community please upload some screenshot/example image.
There is absolute no problem with the formula or syntax. Now question is where are you using this function(in which object), thats matters.
I have created few rows of sample data and tried that function, it gives output without any problem. See the attached Qlikview document.
I have used this function in Chart but it will not work in Text object. As it will give multiple result and text box shows only one value. Please share some more details about it.