I'm using apex 5.1 and universal theme.
I have a page with classic report that is based on apex_collections.
select c001 amount_due from apex_collections where collection_name = 'test'
Type = plain text
Format Mask appearance = 999G999G990D00
Compute Sum = Yes.
If you look at the output for the amount_due its all valid numbers but the mask is NOT applied and the total is zero.
Why are you storing number values in a VARCHAR2 column? Either store values used in calculations as NUMBERs in the N001-N005 collection columns, or explicity convert VARCHAR2s to NUMBERs in the report query using
The same principle applies to using D001-D005 for DATE values.
If more than 5 number or date columns are involved, then its good practice to create a view on the collection(s), either to create a conversion layer over character column storage, or to join two or more collections together to increase the number of native Nxxx or Dxxx columns available.
You keep number values in char type column.
If you can, use n00x column. If you cannot, use to_number(c001).