2 Replies Latest reply: May 15, 2014 10:05 AM by Data Kruncher RSS

    Compare two different fields

    adonis _

      Hi All

       

      Question as follows:

       

      There are 2 fields as follows and 3rd field which does a lookup which i named Und Price as the final output:

       

      Und Sec Price, Lookup Price, Und Price

       

      What i want to do is a lookup formula to provide me the price in Und Sec Price when no price or null value is available in the column in Lookup Price.

       

      If data is available in Lookup Price, I want it to over-write the Und Sec Price.

       

      The final output is shown in the Und Price, which would show the combination.

       

      I was thinking of doing a case statement but how could I do that here?

       

      Thanks

      Adonis

      Happy Veterans day to fellow Vets like myself.