juser2013 Posted November 21, 2013 Share Posted November 21, 2013 Hi,Can anybody tell me how can I format values in Drill Through table? i.e. I am seeing value as 6.000000 instead of 6. My datatype is Number and there is 0 precision defined for it. But still in Drill Through table I am getting 6.000000 ? This is a Hierarchy Level in my Schema. When i perform a drill through on my pivot table, i saw that my values are in decimal and in pivot they are normal.How can I format this value?? Link to comment Share on other sites More sharing options...
ajinkya_c Posted November 22, 2013 Share Posted November 22, 2013 Hi,Use datatype as java.lang.integer which may returns integer part only.ThanksAjinkya Link to comment Share on other sites More sharing options...
juser2013 Posted November 22, 2013 Author Share Posted November 22, 2013 Hi Ajinkya,I tried with integer also, but still I am getting the same output as before. Link to comment Share on other sites More sharing options...
ajinkya_c Posted November 22, 2013 Share Posted November 22, 2013 Hi,Use trunc function with your field which may returns only integer part.Thanks,Ajinkya Link to comment Share on other sites More sharing options...
juser2013 Posted November 22, 2013 Author Share Posted November 22, 2013 Hi Ajinkya,This is a Hierarchy Level , not any Measure?? Can you please explain me how to use function on Levels ??? Thanks, Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now