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
