1 Reply Latest reply: May 15, 2013 2:56 AM by Kumar Natarajan RSS

    IF function

    Adotey Kwame

      Hi,

       

      Can I get help transforming this logic into a syntax;

       

      IF 'Current Date' minus 'Transaction Date' greater than 180 days and Balance(Fieldname) is greater than zero than '> 180',

      IF 'Current Date' minus 'Transaction Date' greater than 90 days and Balance(Fieldname) is greater than zero than '> 90',

      IF 'Current Date' minus 'Transaction Date' greater than 60 days and Balance(Fieldname) is greater than zero than '> 60',

      IF 'Current Date' minus 'Transaction Date' greater than 30days and Balance(Fieldname) is greater than zero than '> 30'    AS AGEING;

        • Re: IF function
          Kumar Natarajan

          Hi,

           

          See the below mentioned syntex. this very usefull for you.

           


          if(Interval(Today()-DueDate,'DD')<=0,Dual('Not Due',0),

          if(Interval(Today()-DueDate,'DD')<=30,Dual('1-30',30),

          if(Interval(Today()-DueDate,'DD')<=60,Dual('31-60',60),

          if(Interval(Today()-DueDate,'DD')<=90,Dual('61-90',90),

          if(Interval(Today()-DueDate,'DD')<=120,Dual('91-120',120),

          if(Interval(Today()-DueDate,'DD')<=150,Dual('121-180',180),

          Dual('> 180',181)

          ))))))
          as AGEING,

           

           

           

          The use Dual() function for sorting orders