How to change the column name in OBIEE answers that are used for BI publisher embedded report 10.1.3

Hi,

I have this embedded bi publisher report 10.1.3.4.2 which is using OBIEE answers as data source. (OBIEE 10.1.3.4.2)

Now I need to add a formula to handle null value.

When I did that, the field name changes and the BI publisher template rtf cannot read this field, even though I tick the custom heading and put back the original name.

Is there a way to change the column name after I put a formula to handle null value?

I am trying to avoid rebuilding the complicated report .

Thanks in advance for any advice.