Does the format field in Application Studio Data view actually do anything?

Kinetic ERP
1

Hello,

I just ran into an issue that I have not seen before.

I was creating a new dashboard in application studio and noticed that a calculated field I use to get percentage is not showing as percent.

The calculation gives it as 0.39 and the format field is set to ->>,>>9.99%

image
image420Ă—247 7.23 KB

This works fine in classic view but not Kinetic.

Classic view:
image

Kinetic view:
image

The relevant data view shows the format field as the same:
image

Any ideas on why?

Is there an easy fix?

Do I just need to convert it in the calculation?

Any help is appreciated!

2

I’ve never gotten the “%” to show in a kinetic grid… period.

I generally multiply by 100 in the BAQ to get the display value I want and then label the column as “Margin %”

I’ve seen other posts on here about percent formatting in kinetic grids and I don’t think I’ve ever come across a working example.

3 Likes
3

Well that just sucks… :sob:

I guess I need to convert that field into a nvarchar and add the percent symbol to it after calculations…

I assume that they will not fix any time soon.

I figured it would be something like this.

Thank you for the quick reply, I really appreciate it!

2 Likes
4

I was trying to think of any standard Kinetic screen that has a percentage value, and the only one I could think of was conversion work bench. They don’t have a percent sign displayed for that either, so most likely you are right and there is no supported way.

2 Likes
5

That’s what we’ve done

1 Like