Page 1 of 1
Format Mask
Posted: Wed Aug 16, 2006 5:20 am
by najm
Dears
I have some Marks Like this
Marks
---------
8
5
6.5
8.4
4.8
3.3
i want to roundup these all in a report i know how to convert it in a round but i have the column of this marks are function and i think there is a Format Mask field i want to roundup these marks through format mask how can i do this.
After Format Mask / Round up the marks should be
Marks
---------
8
5
7
5
4
Najm
Posted: Thu Aug 17, 2006 2:44 am
by admin
You can use 99 or NN hope will solve your issue.
Posted: Thu Aug 17, 2006 3:05 am
by najm
By Using 99 or NN it's not Round up the values Mean when i use NN or 99 the number like
2.2 convert into 2 -- but i want it 3 completly roundup
4.2 convert into 4 -- but i want it 5 completly roundup
5.5 convert into 6 -- but i want it 6 completly roundup
6.7 convert into 7 -- but i want it 7 completly roundup
Najm
Posted: Thu Aug 17, 2006 4:44 am
by Atif
I think u need this
SQL> select ceil(2.2) from dual;
CEIL(2.2)
---------
3
SQL> ed
Wrote file afiedt.buf
1* select ceil(4.2) from dual
SQL> /
CEIL(4.2)
---------
5
SQL> ed
Wrote file afiedt.buf
1* select ceil(5.5) from dual
SQL> /
CEIL(5.5)
---------
6
SQL> ed
Wrote file afiedt.buf
1* select ceil(6.7) from dual
SQL> /
CEIL(6.7)
---------
7
Posted: Sat Aug 19, 2006 4:09 am
by mirza_rehan
Assalam-o-alaikum
Najm Atif is absolutly right use CEIL function
take care
Allah Hafiz
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Posted: Mon Aug 21, 2006 5:24 am
by najm
It's ok i know about the Ceil i use it frequently but i want to say that how i am using the Cail in a Summary Column r u understand i mean how i use this Ceil in Summary Column.
Najm
Posted: Mon Aug 21, 2006 6:11 am
by mirza_rehan
Assalam-o-Alaikum
You use Formula column in save group where Summery column exist.
For example you Summery column name cs_Marks
Create formula column name cf_Marks
write this code in this formula column
<b>Return(Ceil(:cs_Marks));</b>
Hope it will solve yours problem, if any confusion please reply
take care
Allah Hafiz
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family