Analytics Software

hi frnds,

I'm new to obiee, i have a small issue can you please help me regarding the following.


i calculated logical column of count(men) in bmm layer.

i represented the same count(men) in report. even i report i require percentage, so i duplicated count(men) and then i changed the name as men% , i calculated men% by ( count(men) / total(men) ) * 100.

the results are showing fine.

But, its reading in this manner 0-0.9% --- is showing as 0% ( with decimal 0 ) -- 0.0% ( with decimal 1) .. 0.00000% ( with decimal 5)

similarily, its reading 1-1.9% --- is showing as 1% ( with decimal 0 ) -- 1.0% ( with decimal 1) -- 1.00% ( with decimal 2).... 1.000000% ( decimal 6 )

//y its reading 2-2.9% as 2%, 2.0%, 2.00%, 2.000% ( with respective decimal range)

--------------------------------------------------------

how could i rectify this thing and make sure it displays rite result i.e. if it is 0.9% it need to represent 0% ( if truncated) or 1% (if rounded) , 0.9% ( w.r.t decimal pt range 1 ) , 0.90% ( with dec. 2)


Please, guide me.

Thanks in advance.