Percentage formatting

[#1]

hi,

i have table as follows:

order value1	order value 2	total_sales_value
150	87	505
64	99	600
81	45	700

and i am getting output like:

sales %
469.3
271.6
180

i am using formula as - (order value1+order value2)/total_sales_value*100

here i am getting percentage format as shown in table i.e 469.3% using 12.3% number formatting also using 12% number formatting ans is - 469%.

but actual expected ans is 46.93%

how to solve this condition?

[shraddha_g]

use expression as

(order value1+order value2)/total_sales_value

Don't multiply it by 100.

[#3]

will it give percentage value without multiplying by 100????

[shraddha_g]

yes..

[shraddha_g]

PFA

[#6]

Attachment

[shraddha_g]

Try now