function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
E_rockE_rock 

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?

IspitaIspita

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.