wm2
6 months agoNew Contributor
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?
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?
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.