How do you format a table row as currency but not the column field only a specific row?

EmEdwards — Wed, 23 Jan 2019 13:53:58 GMT

I have a table that has various columns of Totals. However, the CurrentYear can represent different information.

I only want to Format the row Category = Money as a currency value = £100000

EG

Category                          CurrentYear
Money                              100000
Cases                                    10
Visits                                     20

I'm unsure how to format a row without formatting the entire column of CurrentYear.

thanks

Re: How do you format a table row as currency but not the column field only a specific row?

renjith_nair — Wed, 23 Jan 2019 13:59:32 GMT

@EmEdwards,

Does this help?

|eval CurrentYear=if(Category=="Money","£".CurrentYear,CurrentYear)

You may add "£".tostring(CurrentYear,"commas") as well

topic Re: How do you format a table row as currency but not the column field only a specific row? in Splunk Search

How do you format a table row as currency but not the column field only a specific row?

Re: How do you format a table row as currency but not the column field only a specific row?