Hi Guys,
I am using following expression and one dimension in a straight table
=Num(Count(Distinct{$<OrderStatusId={2}>}@OrderCaseId) / Count(Distinct{$<OrderStatusId={2,3}>}@OrderCaseId),'0%')
In Qlikview Table Looks as expected without an decimal. But When I use this table in HTML report then the value shows in decimal.
So an Example.. in QlikView it shows like this
Customer | Percentage of Orders On Hold |
---|
Customer A | 27% |
Customer B | 8% |
But NPrinting 16 HTML Report represent the table as below
Customer | Percentage of Orders On Hold |
---|
Customer A | 0.268598277 |
Customer B | 0.084377447 |
The Table is ticked for keeping the source format but I don't know whats wrong.
Can anyone please advice