4 Replies Latest reply: Jan 9, 2017 5:52 AM by Henrique Demarco RSS

    Different results using same formula (table x script variable)

    Henrique Demarco

      Dear all,

      I am having some difficult to understand why a formula assinged to variable in script is not returning the same result as formula wrote directly in a table.

      So my table is:

      QVTable.JPG

      [Tempo Calendario] is =Sum(Duração_turno)

      QVTempoCal1.JPG

      [Tempo Calendario2] is tempo_calendario  (variable)

      QVTempoCal2.JPG

      in script I have

      Set tempo_calendario= =Sum(Duração_turno);

      QVScript.JPG

       

      I'd like to get [Tempo Calendario] result, but with variable assign because the same formula is used many times. Variable will save my time upon any change.

      Any idea on how to handle this?

      Thanks in advance.

      Henrique