3 Replies Latest reply: Jul 25, 2012 11:24 AM by lewiscooksey RSS

    Nested IF Statement

      Is it possible to nest an IF statement within another IF statement? So for example for the below... would that be the best way of doing things?

       


       

      If(Len(NetSalesValue) > 9, 0, NetSalesValue)  as [Invoice Value],

       

      if(NetSalesValue < 0, NetSalesValue, 0) as [Credit Value],

       

       

       

      I would like to still apply the Invoice Value IF to the Credit Value.