Last Modified Date: 22 Apr 2016
AnswerThis answer assumes you have already created a parameter to toggle between two different measures. Refer to the attached packaged workbook to see this example.
1. Select Analysis > Create Calculated Field.
2. In the Formula text box, type a formula similar to the following:
when '<measure1>' then left(str(avg(measure1)*100), 3) + "%"
when '<measure2>' then "$" + (if sum(measure2)>99999 then left(str(sum(measure2)), 3) + "," + mid(str(sum(measure2)), 4, 3) end)
2. Drag the calculation to Text.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials