make format mask work with either displayonly or Number field
APEX 4.0, 11g. I have a number field with the value 132.5 (it's a number 10,2 in the DB). I set the item's Format Mask to FML999G999G999G999G990D00 (under settings) but it's still showing up as 132.5
I changed it to a type of displayonly and set the source to
SELECT TOT_FINE_AMT
FROM CLIENT_TABLE
WHERE XREF_NBR = :P12_XREF_NBR and the format mask at the bottom of the Source area to FML999G999G999G999G990D00 and it's still showing up 132.5
I tried with the item type as both Number and Displayonly and set the source to
select to_number(TOT_FINE_AMT, 'FML999G999G999G999G990D00') but in both cases it still shows as 132.5
obviously there has got to be a way to make a format mask work... any ideas? (Ideally it'd be a displayonly field because it is not editable, but if I can only get it to work with Number type, that's okay too)