Hi,
I believe the headline says it all.
I configured a pivot on a interactive report, the pivot has currency and percentange columns.
The function for currency columns could be formatted in format model as 'FML999G999G999G999G990' (no cents).
But the percentage values?
How to get formatted a value as e.g. '999G990D0 %'? (This produces an invalid format model error).
In the report attribute 'Column Formating', I added a HTML Expression '#MYPERCENTVALUE#%' to the column from where the pivoted values are derived.
But this had no effect, probably because the APEX pivot function build its own columns, which are fomatted using the format model field in the pivot configuration.
But how to add a percent sign to a pivot report value?
Thank you very much!
(Oracle-XE 18c, APEX 18.2)