SOLVED

Format a decimal

%3CLINGO-SUB%20id%3D%22lingo-sub-313261%22%20slang%3D%22en-US%22%3EFormat%20a%20decimal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313261%22%20slang%3D%22en-US%22%3E%3CP%3EAll%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20created%20a%20KQL%20query%20that%20outputs%20a%20value%20like%20%2211.4030237198%22.%20How%20can%20I%20format%20this%20output%20to%20just%20display%20the%20it%20like%2011.4%20or%2011.40%20instead%20of%20the%20long%20number%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-313261%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuery%20Language%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313497%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20a%20decimal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313497%22%20slang%3D%22en-US%22%3E%3CP%3EBrilliant!%20Thanks%20for%20responding!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313325%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20a%20decimal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313325%22%20slang%3D%22en-US%22%3EThis%20is%20exactly%20why%20we%20have%20the%20round()%20function%20%3A)%3C%2Fimg%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fkusto%2Fquery%2Froundfunction%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fkusto%2Fquery%2Froundfunction%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

All,

 

I've created a KQL query that outputs a value like "11.4030237198". How can I format this output to just display the it like 11.4 or 11.40 instead of the long number?

2 Replies
Highlighted
Solution
This is exactly why we have the round() function :)
https://docs.microsoft.com/en-us/azure/kusto/query/roundfunction
Highlighted

Brilliant! Thanks for responding!