Discussion board where members can get started with QlikView.
i have a column name is rate and now values showing as 100.00000455 [ this column is coming from directly from DB]
i want to get as a new column with 100.00%
Hi Sony, maybe this
Num(100.00000455, '#,##0.00') & '%'
View solution in original post
thanks for your response. second one looks cool
can you have look on below thread.
but it is showing all 100.00% only... as i have data like 99.988 it should not round.
it should show 99.98% ..
and can u have a look into this?