Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesIt would be useful to allow for temporary local variables in formula tools. This could make code shorter, better readable, easier to maintain and help to avoid auxiliary columns which have to be deleted afterwards.
Arbitrary example for illustration:
if Length([Col1] + [Col2] + [Col5]) > 50 then
Left([Col1] + [Col2] + [Col5], 48) + "..."
else
[Col1] + [Col2] + [Col5]
endif
versus
tmpstr = [Col1] + [Col2] + [Col5]
if Length(tmpstr) > 50 then
Left(tmpstr, 48) + "..."
else
tmpstr
endif
The idea is that the temporary variable has limited validity inside the formula for a specific cell.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.