How to convert values into % after dividing

[P_Kale]

Hi,

I am dividing two values and calculating % but out-put i am getting in decimals instead of %. How I can achieve this. Below given formula I am using to calculate %.

1) Count({< SALES ={'Sales'}>}  POLICY_NO) / Count(total <FY_YEAR> POLICY_NO) * 100

2) Sum({< SALES ={'Sales'}>} SALES_AMT) / sum(total <FY_YEAR> TOTAL_SALES) * 100 / 100

below given is the out-put i am getting. But what i want is

0.73% , 7.5%,

1.10%, 11.8% and so on

FY_YEAR	Total sales	Sales	% in Sales	Total SA	SA	% SA
Totals	2116978	15455	0.73	13,091.10	984.85	0.08
FY_2015-2016	242149	2655	1.10	912.97	108.16	0.12
FY_2016-2017	216278	2499	1.16	986.72	126.56	0.13
FY_2017-2018	222493	1922	0.86	1,219.27	106.01	0.09
FY_2018-2019	212522	2434	1.15	1,375.59	157.66	0.11
FY_2019-2020	195382	2295	1.17	1,309.45	166.97	0.13
FY_2020-2021	245969	1966	0.80	1,454.59	193.95	0.13
FY_2021-2022	257494	1076	0.42	1,776.07	81.24	0.05
FY_2022-2023	300335	522	0.17	2,290.29	38.08	0.02
FY_2023-2024	224356	86	0.04	1,766.15	6.21	0.00

@marcus_sommer 

@sunny_talwar 

@Anil_Babu_Samineni 

Thanks in advance

[qv_testing · Accepted solution]

try with this using number format

num(Sum({< SALES ={'Sales'}>} SALES_AMT) / sum(total <FY_YEAR> TOTAL_SALES) , ''##.0%')

[NellyAcko]

Either use the Num() expression OR the built-in 'Number Formatting' shown below

[jochem_zw]

create an expression and use the formatting property and set it to %

[Anil_Babu_Samineni]

@qv_testing I Guess the format needs to be this , Num(Your expression, '#.#0%')