Dear all,
I have a number of a!gridTextColumn s in my paging grid component and I would like to format the text to show in "###,###,###.##" format. Here below is the code for the grid columns. Does anyone have a suggestion for how I can get the number columns to show formatted text?
Thanks.
-----------
=load( local!pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 20 ), with( local!datasubset: a!queryEntity( entity: cons!CSHV_LINE_ITEM_CDT, query: a!query( selection: a!querySelection(columns: { a!queryColumn(field: "itemName"), a!queryColumn(field: "amount"), a!queryColumn(field: "qty"), a!queryColumn(field: "total"), }),
filter: a!queryFilter( field: "cashAdvnaceId.id", operator: "=", value: ri!CashAdvanceData.id ), pagingInfo: local!pagingInfo ) ), a!gridField( totalCount: local!datasubset.totalCount, columns: { a!gridTextColumn( label: "Item", field: "itemName", data: index(local!datasubset.data, "itemName", null) ), a!gridTextColumn( label: "Amount", field: "amount", data: index(local!datasubset.data, "amount", null), alignment: "RIGHT" ), a!gridTextColumn( label: "Qty", field: "qty", data: index(local!datasubset.data, "qty", null), alignment: "RIGHT" ), a!gridTextColumn( label: "Total", field: "total", data: index(local!datasubset.data, "total", null), alignment: "RIGHT" ) }, value: local!pagingInfo, saveInto: local!pagingInfo ) ))
Discussion posts and replies are publicly visible
Hi Susan,
The dollar() function might be helpful to you here, which will format a given number as "$###,###,###.##".
If you want to drop the dollar sign, you can try to use stripwith() around it, ex:
stripwith( dollar(123456), "$")