Using Text function in Financial Reporting

Hi All,

In the FR report that I am working on currently, I am using a text function for the Custom heading. I am trying to get the value of a cell using GetCell function. The issue occurs when there is no data or 0 in the cell, the value in the custom heading shows as $- rather than $0.

I used conditional formatting to replace the cell with 0 if there is no data, still no luck.

Also, this is the function that I am using :

Deferred financing costs, current, net of accumulated amortization of $<<GetCell("Grid1", 13, E,1)>>  as of <<MemberDescription("Grid1", E, "Period")>> <<MemberDescription("Grid1", E, "Year")>>