Hi
I'm still using Impromptu at the moment so some of you may have to think back a bit. I have a calculated column in my column e.g. Sales/Total Sales) *100 so that I get a percentage. I then have a prompt for this result so I can select a range e.g. from 1 to 5 %
However when I check my results I can still see lines with 0.64 or 5.04 so there is still some round here. When I look at the Query Columns tab I can see my calculated has been set to Length 8, Precision 0 and Scale 0. I'm gussing this is where the issue is, a 0 scale.
Has anybody else had this issue and how did you resolve it so that decimal places on not rounded.
Thanks
Nav
I'm still using Impromptu at the moment so some of you may have to think back a bit. I have a calculated column in my column e.g. Sales/Total Sales) *100 so that I get a percentage. I then have a prompt for this result so I can select a range e.g. from 1 to 5 %
However when I check my results I can still see lines with 0.64 or 5.04 so there is still some round here. When I look at the Query Columns tab I can see my calculated has been set to Length 8, Precision 0 and Scale 0. I'm gussing this is where the issue is, a 0 scale.
Has anybody else had this issue and how did you resolve it so that decimal places on not rounded.
Thanks
Nav