% decimal points

Hi Community , I have formatted the numeric field to percentage
Now I want the numeric field to show decimal points according to the decimal parameter I’ve created

But the parameter seems to not be working
How Can I achieve what I want?

Hi @Vysh27
please share the formula of the calculated field and format option in the table.
BR

1 Like

image

here you go @ErikG

How are the decimal places formated? Auto?

1 Like

Yes @ErikG

I tried by myself, but added a sum in the formula.

1 Like

But I want the numbers to be shown as eg .174,555.62%

The “format to percent” is showing the numbers as “multiplied by 100”. Maybe just “divide by 100”?

1 Like

Yes @ErikG . It worked
Thanks a lot!!!

Perfect.
Could you please solve the topic?

1 Like

As long as all sharing one measure you want.
You could create measureN and measureP but you will get two columns.

can’t we get it in one column?

I guess no. Would not recommend it anyway. As you have the “%” within the text it should be clear.

Based on the screenshot, I can’t say what the percentage values mean. 71.8% of what?

And thats a QS visual?

Yes @ErikG , it is a quicksight visual

Do you have more than an small screenshot?
Looks like a pivot table but any chance to get more information?

Looks a bit like.

But the complete definition I would also be interested.

Will try and see if anything else works
If you get any solution pls let me know
Thanks!