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

    Number Format error SLA calculation?

    Bradley Coyne



      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.