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

[EmEdwards]

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

[renjith_nair · Accepted solution]

@EmEdwards,

Does this help?

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

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