Number Format error SLA calculation?

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

TotalAllowance is 48. That means 48 days if you use it as an interval. If you use num(duration) you can see how that compares to TotalAllowance. You either need to divde TotalAllowance by some factor or multiply Duration with a factor so both can be compared correctly.