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.