Forum Discussion
Michael_Waterman
Jan 10, 2019Copper Contributor
Format a decimal
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?
- This is exactly why we have the round() function :-)
https://docs.microsoft.com/en-us/azure/kusto/query/roundfunction
3 Replies
- Meir_Mendelovich
Microsoft
This is exactly why we have the round() function :-)
https://docs.microsoft.com/en-us/azure/kusto/query/roundfunction- SocksofGranduerCopper Contributor
Is there a clean way to always force the output to always show exactly 2 decimals?
For example, if I have a data set of 4, 1.2, and 6.7811 it would output as: 4.00, 1.20, 6.78
- Michael_WatermanCopper Contributor
Brilliant! Thanks for responding!