APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Formatting Negative Amounts in Interactive Grid

Vaibhav GajareJul 17 2025 — edited Jul 17 2025

I’m trying to format negative amounts (e.g., $-2000) in an Interactive Grid so that they appear as ($2000). To achieve this, I’m using the format mask:

FML999G999G999G999G990D00PT

However, this format works correctly in an Interactive Report but shows as an invalid format in the Interactive Grid.

Can anyone suggest a better way to accomplish this formatting in the Interactive Grid?

Thanks in advance!

Added on Jul 17 2025

#apex, #fmlformat, #interactivegrid, #negativenumbers, #numberformatting

6 comments

126 views