Formatting in Drill Through
Posted on November 21, 2013 at 5:26am
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??
Joined: Mar 19 2013 - 3:47am
Last seen: 9 years 8 months ago
Posted on November 21, 2013 at 9:46pm
Hi,
Use datatype as java.lang.integer which may returns integer part only.
Thanks
Ajinkya
Joined: Aug 29 2012 - 6:13am
Last seen: 6 years 6 months ago
Posted on November 21, 2013 at 9:50pm
Hi Ajinkya,
I tried with integer also, but still I am getting the same output as before.
Joined: Mar 19 2013 - 3:47am
Last seen: 9 years 8 months ago
Posted on November 22, 2013 at 1:45am
Hi,
Use trunc function with your field which may returns only integer part.
Thanks,
Ajinkya
Joined: Aug 29 2012 - 6:13am
Last seen: 6 years 6 months ago
Posted on November 22, 2013 at 1:54am
Hi Ajinkya,
This is a Hierarchy Level , not any Measure?? Can you please explain me how to use function on Levels ???
Thanks,
Joined: Mar 19 2013 - 3:47am
Last seen: 9 years 8 months ago