You need to sign in to do that
Don't have an account?
Left function limits?
I have created a report, that I am calling with a custom link. Currently, I am passing /#############?pv0={!Lead.Field} where ### is the report number. I wanted to only pass the first four characters of thelead field and tried to use the left function to do so. The result I get is not expected. Instead of giving me only the first four characters, it passses the following Left(12321223,4). In another words, it is retrieving the value of the field 12321223, but not utilizing the Left function functionality. Is there a way to do what I am trying to do? Pass only the first 'X" number of characters from a field?
Is it a number field? If yes then you perhaps need to use text() function in your formula.
Something like this :-Left(text(12321223),4) may work.