I have a matrix w/inserted blank lines that I thought I could use a unichar vs zero. The measure "Blank Rows" is a if statement, and it true - currently displays a zero. And then this "Blank Row" measure is included in the BalanceSheet measure. What I thought I had read/watched - there is a unichar that could be substituded for zero, thus forcing a blank row inside the matrix. The unichars I have tried all result in a error within the BalanceSheet measure.
Is there a known blank unichar that still allows a blank row, but also valid in a numeric measure.
Another approach - is to use change the transparency within conditional formatting. Is there a way to format "Blank Rows" measure as transparent inside the balancesheet measure?
Always appreciate the awesome community support!
Solved! Go to Solution.
AWESOME! Thank you!
I watched your link to excel formatting - I've been using excel most of my career - and seems there are always new things to learn. Thank you!.
You can use a Custom Format String to hide the 0's. I explain how this works here
For example for decimal numbers you could use this Format String 0.00;0.00;;
Before applying the Format String
After applying the Format String
Oh wow - possibly a very clean and easy solution - that won't affect further calculations. However, the format string provided, I lost the 1000's (comma) separator. I tried a few quick ideas, but no success.
Ironically - I studied your artical in my research yesterday. Guess, my feeble mind overlooked or was focused on something else as I glanced thru 🙂 Thank you