1 Reply Latest reply on Jan 20, 2012 7:07 AM by RichardPaul

    Days Due calculation?



      Days Due calculation?


      I have upgraded to ver. 11 from ver.6.  my days due calulation works great except when there is not a date entered in the invoice date feild.  when no date is entered, my days due is 734522 (I believe that it is assuming it is 0 as the date and using "absolute date" as my days due.  My calc. is  if(getasnumber(amount Paid) <(order total + finance chg);today-invoice date;0)  Need hlp with this field.  

        • 1. Re: Days Due calculation?

          You can either nest an if into your calculation eg

          if(isempty(invoice date);""; if(getasnumber(amount Paid) <(order total + finance chg);today-invoice date;0))

          or the cleaner solution would be to use the case function

          case(isempty(invoice date);"";getasnumber(amount Paid) <(order total + finance chg);today-invoice date;0)

          You can replace "" with whatever value or calculation suits your requirements

          Hope this helps