Skip to Main Content

APEX

Announcement

Testing banner

Do math with 2 number fields that have format mask set

Workspace: FX_WS_4601
App: 1402
Page: 4,3

I have 2 number fields on page 3. I am using simple setup to set the 3rd field to be sum of the 2 numbers. I have the currency format mask (L999,990.00) on all 3 number fields.

I get the following error. Ajax call returned server error ORA-06502: PL/SQL: numeric or value error: character to number conversion error for Set Value.

If I remove the format mask then the math works and there is no error. Can you please guide on how to make this work?

Comments
Post Details
Added on Jan 31 2023
3 comments
26 views