topic Re: How to convert values into % after dividing in App Development

How to convert values into % after dividing

P_Kale — Fri, 02 Feb 2024 15:49:21 GMT

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

Re: How to convert values into % after dividing

Nagaraju_KCS — Fri, 02 Feb 2024 16:08:58 GMT

try with this using number format

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

Re: How to convert values into % after dividing

NellyAcko — Sat, 03 Feb 2024 23:51:53 GMT

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

Re: How to convert values into % after dividing

jochem_zw — Sat, 03 Feb 2024 21:06:33 GMT

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

Re: How to convert values into % after dividing

Anil_Babu_Samineni — Sun, 04 Feb 2024 05:10:46 GMT

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