Decimal amount not displaying in log Analytics query

Deleted
Not applicable

Hi I have a really simple query

 
ApplicationInsights
| where TelemetryType == "Availability"
|summarize count() by AvailabilityResult
|summarize failedCount=sumif(count_, AvailabilityResult == "Fail"), totalCount=sum(count_)
|extend (failedCount / totalCount)
 
but the "extend (failedCount / totalCount)" is just displaying as a 0, its a really small decimal .003...how do I display this as a decimal value?
 
2 Replies

Two valid options:

1) explicit type casting to floating point:

 

... | extend failureRate = todouble(failedCount) / todouble(totalCount)

2) implicit type casting:

... | extend failureRate = failedCount * 1.0 / totalCount
|summarize count() by AvailabilityResult
|summarize failedCount=sumif(count_, AvailabilityResult == "Fail")+0.00000, totalCount=sum(count_)+0.00000
|extend avail=100 - ((failedCount / totalCount)*100)
 
adding by this decimal forces a cast to decimal.