Grid model editor having no effect on calculated decimal fields

Kinetic ERP
1

Hey all,

On one of my Kinetic dashboards, I’m got a decent set of decimal fields sourced from calculated BAQ fields. In the dataview, they show properly as decimal. These fields represent cost, and it would be nice to display them in traditional currency format (e.g. $123,000.00). By default they are displayed without the dollar sign or any commas, and too many fractional decimals. Normally, I have been able to correct this by changing the column editor to currency or decimal.

In this case, I’ve tried both, but nothing seems to have any effect on how the field is displayed. I’d prefer to keep the column as a decimal type so sorting works correctly vs creating a formatted string version of the column in the BAQ.

Does anyone have any suggestions?
Dataview Columns

image
image1262×426 10.2 KB

Field Config

image
image401×907 19.5 KB

ERP Editor “Number” Config
Note that selecting currency also has no effect.

image
image399×673 10.4 KB

2

I think you have to set the mask.

1 Like
3

What would an example of that look like?

4

I would try to look at an existing app that shows the format you want, and see what mask its using in app studio. I know 999 works for a whole number but you might have to experiment for getting the right number of decimals.