Format Mask

[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

[admin]

You can use 99 or NN hope will solve your issue.

[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

[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

[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

[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

[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