1 of 1 people found this helpful
If you format the number in the Measures view (as opposed to clicking on the pill in the worksheet and selecting Format... from the drop-down menu) then the format used in the Title will change.
Otherwise you'd need the calculation to be something like:
STR(ROUND([calculation],0)) + "%"
Thanks, Jonathan, that was a great tip! I went to the Measures view, and clicked on the measure I was trying to format as a percent, and went to the Format drop-down menu, but couldn't find an option for formatting the number, which is odd consdiering the title "Format" of the drop-down! However, when I right-clicked on the measure, it brought up a menu, which included "Field Properties". I hovered over this and it brought up a "Number format..." option which allowed me to change the format to a percent, and now the title appears as desired. Thanks for your help on this!
- Jon Naatjes