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

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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)"