Formatting Column Data in Kinetic Dashboards

Where do I format column data in Kinetic dashboards? We have a request to add commas for large amounts on some columns and hide decimals for another, but I don’t see the format field in the grid properties fields in App Studio (like we would for a stand alone numeric field).

Is it done in the BAQ?

Thanks for the help!

1 Like

Have you looked into the Grid Model > Columns > ERP Editor?

Basically choose your data type there… then click into the Erp Editor Model:

All kinds of settings in there to play with. Look under Advanced. There’s another format sub section and also a mask where you can put things like ->>>,>>>,>>9

1 Like

It might also be worth taking a look at the Data View and changing the format there. I changed the OrderNum in the landing page of Order Entry here for example.


1 Like

Thanks @dcamlin! That was it.
@tsimon - Thanks! Good to know about that option as well.