This content has been marked as final. Show 6 replies
i have table as follows:
|order value1||order value 2||total_sales_value|
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?