Forum Discussion

wm2's avatar
wm2
New Contributor
6 months ago

Formatting Reports

Hello,

I am trying to format this so the Total Assets/Liabilities/SE at the top is just a header without numbers.

Does anybody know the correct formula?

 

  • T_Kress's avatar
    T_Kress
    Contributor III

    If you go into the cell formatting on those rows, you can change the cell text color to transparent which will make the numbers disappear. That looks like this:

    But if that is truly just a header row or label row you can set the account as follows on that row:

    And then account none will not pull any numbers and you can still use the cell transparent text as listed above.

    What I like to do is set up a row format that is called:  Row_BlankCell in dashboard parameters.  In the dashboard parameter it will look like this:

    Then I apply that format in the default section of a cube view for any rows that contain the word "Header" as an example.  And then as long as you start all these header rows with something like "HeaderTotAssets" they will get the right formatting applied.

     

    • wm2's avatar
      wm2
      New Contributor

      That was perfect, thank you so much.

      Last question, do you know how to bring the column header down so it is even with the row header? 

      Thank you!!

       

      • T_Kress's avatar
        T_Kress
        Contributor III

        Check your indentation on the head vs regular rows.  It appears you have indented the data rows: