HI,
We are using APEX 20.1. We have a dynamic CR with Generic column count set. This is basically a pivoted report.
My table structure is
CREATE TABLE test_tab(
user_name VARCHAR2(100),
question_num NUMBER, -- foreign Key to questions master table
answer_value VARCHAR2(500)
)
I pivot the data in this table as a Classic report.
Some of the questions have answers as NUMBERS. I want to format the numbers - '999G999G999G999G990D00' and compute the SUM on these columns. So I set the Format Mask to '999G999G999G999G990D00' on all the columns.
Compute SUM is working along with the format number. But the actual values are not formatted themselves.
If I use to_char(answer_value, '999G999G999G999G990D00') in my query itself, the values are formatted, but the COMPUTES SUM doesnot work.
Please suggest.
I have created an example on apex.oracle.com.
ws - vpwstest
user - testuser
pwd - abcABC@123
app - Application 92756 - VP Test App
page - 2 - Test Number Format
Thanks