Forum Discussion
Solved
Score Card using symbols
Really needing an expert on this one..... I am creating a score card that I have pulled off You Tube. I have the sample BI to copy and have benn doing great until now. I am trying to add a symbol...
I think you have % part of the text/value. Try this.
SelectItem = 12 && (VALUE( SUBSTITUTE([Classic prioritizes overall safety],"%","") ) / 100) >= 0.90
Tested:Column2 is calculated column and its syntax:
Measure syntax:
I was doing fast copy paste and has to do multiple edits in this reply. 🙂
I think you have % part of the text/value. Try this.
SelectItem = 12 && (VALUE( SUBSTITUTE([Classic prioritizes overall safety],"%","") ) / 100) >= 0.90
Tested:
Column2 is calculated column and its syntax:
Measure syntax:
I was doing fast copy paste and has to do multiple edits in this reply. 🙂
You are my HERO!!!!!!! thank you so so much. This has been making me crazy. I appreciate you willingness to help.
Thank you,
Wendy