cancel
Showing results for 
Search instead for 
Did you mean: 

how to format a LOV to have only 2 decimal places?

Former Member
0 Kudos
56

I have a calc, however, within the LOV, I'm getting values with more than two decimal places... how can I format this so the user sees a LOV with only 2 decimal places?

I ahve tried to object format, with no success

code:

floor(months_between(trunc(sysdate),Table.DOB)) / 12

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

If you execute that formula directly on your database (for example using Toad) does this format work?

Former Member
0 Kudos

Ugh...

OK, got it to work...

changed code;

From: floor(months_between(trunc(sysdate),TABLE.DOB)) / 12

To: floor(months_between(trunc(sysdate),TABLE.DOB) / 12)

*Moved paren's after "TABLE.DOB)"

Answers (0)