C2 Explorer, Widget=TABLE, format column as currency?

C2 Explorer
1

how do I format the column in a C2 Explorer TABLE widget, to be displayed in the grid as a currency $0.00 ?

this does not work :frowning:

select new
{
trade.Symbol,
trade.Result.ToString(ā€œCā€)
};

is it possible ?

2

Hello!

This works:

long[] systemIds = {128022277,130054513 } ;

TABLE = from trade in C2TRADES
  where systemIds.Contains(trade.SystemId)
  select new { 
               System = trade.SystemId,
               Symbol = trade.Symbol,
               Result =  trade.Result.ToString("C")
             } ;

image