3 Replies Latest reply: May 15, 2014 10:12 AM by scrtchmstj _ RSS

    Null value in a calculated value numeric field

    scrtchmstj _

      I am using the lsplit function to split GL numbers (in text format) into primary and sub numbers. For example, "745-908" would be split into two columns 745 and 908. The problem comes when my model sees a GL with only a primary number like "720". In such a case, it returns the values 720 and 0.

       

      I was going to use these results to pull activity for a GL by primary and sub numbers but unfortunately there is a difference between the criteria 720 null and 720 0. Is there any way to have a calculation display a blank value (null) instead of a zero?

       

      Joshua