0 Replies Latest reply: May 15, 2014 10:09 AM by joey RSS

    User Defined Functions

    joey

      I'm curious - what kinds of user defined functions are you using?  I've not created more than a handful of functions, since most of mine are unique to the report. 

       

      The ones that I have created are:

       

      -Convert a zoned decimal to a normal number.   For example 006J is converted to -61.

      -Convert a normal number to zoned decimal.  The opposite of what is above.

      -LPad and RPad a string up to a certain length with a certain character.

      -SpacesOrValue, which takes a field and converts nulls to spaces or the value of the field if it is not null.

       

      What others have people found to be generally helpful? I'm looking to possibly expand the shared toolkit I've created for the company.