Kinetic Grid Column Format Application Studio

Kinetic ERP
1

Hello all,
I’m struggling with a simple thing.
We have a BAQ and Classic Dashboard that displays a calculated percentage (rework):
image
The same BAQ in Kinetic shows as a decimal:
image

The dataview definition looks like this:

image
image859×44 1.97 KB

The grid calls the BAQ directly from a View:

image
image370×783 9.35 KB

And the columns are defined in the panels Grid Model:

image
image375×534 7.92 KB

I’ve tried just about every permutation of “Erp Editor” / “Erp Editor Model” that I can think of, and I’m really just guessing at this point.

How can I get the Kinetic grid to display the percentage just like the classic grid did instead of as a decimal value?

Thank you!

2

Since it’s a calculated field in a BAQ, you may as well just make a new calculated field to do the math display the percentage as a string with the symbol. It’s gonna be way smoother that way rather than trying to get App Studio to show it properly the other way.

1 Like
3

What are the results in the BAQ designer?

Wonder if this is the issue. The .99%

Agree with @hmwillett update the calc in the BAQ to get the format you want.

4

Because this is annoying:

image
image1362×130 8.43 KB

4 Likes
5

Thanks for taking one for the team, @hmwillett

6

I’m hoping that submitting it under the controlled release will get more traction than standard. :crossed_fingers:

4 Likes
7

Yeah, I was wondering if that was strategic or just to try to at least get it fixed for an upcoming release… then perhaps they can patch previous.

1 Like
8

Lol :skull:

2 Likes
9

Good grief. I didn’t expect to have to go to war on this ticket.

War Fx GIF by BasketsFX

1 Like
10

Like most cases…

Going in:
The Neverending Story Win GIF

Coming out:
SwampofSadness

2 Likes
11

That’ll be support.

I’m gonna call them with an hour of this: The Most Annoying Sound In The World - YouTube

I’m in a fighting mood today, lol.

Lets Fight About It GIF

1 Like
12

image

So there.

7 Likes
13

Thank you all so much for your help!
I’ll set it up as a formatted field in the BAQ. That’s a great idea, and would have saved me a ton of time last week if I had thought of it myself!
You all are the best.
Thank you!!

1 Like
14

Thanks for the work around to change the BAQ to a string, and use Format P0! That helped me out converting a classic dashboard.

App Studio is ignoring the column format style of ‘Percent’ - I created a case as well (CS0004909035).

What’s odd, is that displaying a numeric field as a % in app studio will show the trailing % character if it’s refering to a database field directly, but not if it’s from a numeric calculated BAQ source in a dashboard.

Chalk up another Appstudioism…