Discussion board where members can get started with Qlik Sense.
i have table as follows:
and i am getting output like:
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?
use expression as
(order value1+order value2)/total_sales_value
Don't multiply it by 100.
will it give percentage value without multiplying by 100????