1 Reply Latest reply on Oct 31, 2018 9:41 AM by Jim Dehner

    calculated field is null/is not null

    Anna Adezati

      Hi, I need to create a calculated field that shows this calculation

      if the (spent amount ) is not null put the value if null put the "estimated value" amount.

       

      do youknow which is the correct sentence to create?

       

      thanks
      Anna

        • 1. Re: calculated field is null/is not null
          Jim Dehner

          Tru this

           

          I am assuming that the fields spent amount and estimated value are at the same granularity

          if null work by using the first argument if the value is NOT null and the second if it is

           

                    ifnull([spend amount],[estimated value])

           

           

          Jim

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.