1 Reply Latest reply: May 29, 2013 10:57 AM by Gysbert Wassenaar RSS

    Number Format error SLA calculation?

    Bradley Coyne

      Hi.

       

      i am having difficulties with the following calculation.

       

      i wish to calculate the total calculated time of each case against the SLA time assigned.

       

      the two dimensions are Duration (actual calculation) and TotalAllowance ( the time threshold that the case should not pass)

       

      if(Duration > TotalAllowance, 0,1)

       

      However when i perform this calculation it seems as if the format is not recognized as it doesnt appear to work; in the correct way.

       

      i have attached the Qvw to this message.

       

      Help would be much appreciated.

       

      Best,

      Bradley