0 Replies Latest reply on Dec 26, 2011 10:15 PM by cclay53

    Calculating overtime

    cclay53 Level 1

      I have an expense report and I calculate the overtime but if there is no time entered for that day I don't want to see a zero or -8 in the overtime cell. ph3 value is from a calculation and Row7.cell4 is entered and both are set as numeric fields and this cell is text field. Also, either ph3 or cell4 could have no value entered or they both could have values.

       

       

       

      if (Table1.Row6.ph3 <8) {

      this.rawValue = null;

       

      if (Table1.Row6.ph3 + Table1.Row7.Cell4 >8);

        this.rawValue = (Table1.Row6.ph3 + Table1.Row7.Cell4)-8;

      }