Formatting a!gridTextColumn within a Paging Grid Component

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

Parents Reply Children
No Data