0 Replies Latest reply on Nov 6, 2013 1:32 PM by PretNews

    How do I count the number of weeks without using formcalc's count function?

    PretNews Level 1

      Since I'm using a form with PDF artwork and can't use tables or subforms I need to find a way to count the number of weeks based on the number of non-null date fields. Anyone know how to do this?


      When I use count (Weeks[*]) I get the right number of weeks but I also get


      Error arithmetic over/underflow

      Script failed (language is formcalc; context is


      script = sum (MealsTotal/NumberWeeks)


      When i give each Week feild a unique identifier (ie Week1) I get the same errors so it's the count function that's the stumbling block