Hi-- I created a custom formatting with 2 measures, after the total, I added "(%)" :
Can we add another format that if second measure is null => do not display "(null)"
Thanks,
3 answers
Hi Florent,
I have a simple solution for you.
1) Remove the "()" from the label.
2) Go to the number format of your calculation1
3) Select custom
4) Add the following: "("0.00%")";"("-0.00%")";"("0%")"
I'm pretty sure that should work and will save you the extra calculation.
If this helps you, please mark it as helpful and correct so other users can refer to it. Thanks!
Best,
Diego
