2 Replies Latest reply: Jun 12, 2016 5:50 PM by Nagaian Krishnamoorthy RSS

    Replace null value (or missing value) in source Excel value by 0 in script

    Jeff Robertz

      Why is this syntax not working?

      if(isnull("Risk factor"), '0.0',"Risk factor") as RiskFactor

       

      It seems it delivers a 0 in Excel but that the zero is not well interpreted as my computation using the RiskFactor are not happening.