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
Format Mask
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
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
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
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
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
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
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
Who is online
Users browsing this forum: No registered users and 5 guests