Forum Discussion
Spacing for report structure
Hi All,
I'm trying to maintain a certain type of format for a finance report, but when I try to organize by index, spaces I believe are causing me some issue. The error I'm getting is that it cannot organize by index for duplicate values. Here's a sample of the structure I'm trying to maintain:
Any info helps. Thanks.
3 Replies
Hello swebb ,
Refer to the following videos for building financial reports :
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Unforuntately, I've seen Bas's videos, and the structuring he suggest does not work. I go to filter out the "null" values to circumvent the issue with the indexing/ordering of the rows, but there are no null values to filter. So, I'm still stuck with the issue of being unable to order the rows.
For each column I've added or removed all white space. E.g., I've added 2 blank characters as Bas suggests in column 1 for Net Operating Income at the end, for the second column I've added 1 blank character at the beginning, and trimmed the third column. I've done this for all values for all columns. So, if something exists in column 1, I've added 2 blank space characters, added anywhere from 1 to 8 in the second column for each row value, and then trimmed third column row values. I hope this makes sense.
