currently my simpletresultstable is showing
myDecimalfield1 | myNumfield1 | MyCalculatedField1
1234.56789 | 1 | 1234.56789 <--- myDecimalfield1 divided by myNumfield1
how can I format myDecimalfield1 and MyCalculatedField1 to show only 2 decimal places? thx
Use eval with round().
| eval myField = round(myNumField1 ,2)
http://docs.splunk.com/Documentation/Splunk/4.3.2/SearchReference/CommonEvalFunctions
Then is display the new field (myField) in your table.
Use eval with round().
| eval myField = round(myNumField1 ,2)
http://docs.splunk.com/Documentation/Splunk/4.3.2/SearchReference/CommonEvalFunctions
Then is display the new field (myField) in your table.