Hi , I want to show a percent symbol next to the numeric field of the dataset which also dynamically changes according to the decimal control I’ve created. When I create a calculated field and adding it to the visual it’s taking as a string and it’s giving the count instead of the numerical number. …

Hi @Vysh27 you are creating a string field that cant be summed up. Its like sum A and B. But why not format/show the Sales as Percent? [grafik] BR

when I try to format the sales as percent, the parameter that i’ve created to show the decimal points doesn’t work How Can I make the parameter work by formatting the sales as percent?

Other way around. What do you want to achieve with the parameter and your sales field? Can you share a sample?

[image] As you can when I change the control to 2 the decimals in the numerical field also change to 2

maybe you can have a look into [image] Dynamic decimal places Question & Answer Thank you SO much @wstevens01 . That worked! I just nested that into another ifelse to aoid the ‘%’ to still show up even if the conversion is not applicable. see below. [image] Final calcu…

[image] [image] It’s still taking it as count and not showing the numbers according to the fixed decimal

Because you still creating a sting and not a number.

okay , but how was Gian able to achieve it as a sum and not count Help me with this

Not sure he used sum or was looking on row level. But i would say you will only achieve a sum if you format it instead of casting it into a string.

Any alternate way how I can Achieve what I want? How Can I add the % symbol and Show it as a number and not count

% symbol to the decimal points

Q&A

ErikG December 12, 2023, 11:14am 6

maybe you can have a look into

Topic		Replies	Views
% decimal points Q&A filters , formatting , quick-sight , calculations , Business-Intelligence-Engineer	17	513	December 14, 2023
Dynamic decimal places Q&A quick-sight , Business-Intelligence-Engineer	15	1313	December 13, 2023
Table error Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	6	203	January 10, 2024
Calculated field with 2 types of format Q&A formatting , quick-sight , calculations	4	314	June 21, 2023
Show as number/percentage with dynamic variable Q&A parameters , quick-sight , calculations , Business-Intelligence-Engineer	2	408	November 15, 2023

% symbol to the decimal points

Related topics