Change number in % in dimension

[tracycrown]

Dear all

Kindly help me on this problem.

I encountered problem to convert numbers in Sales% (0.5,1.0,1.5) in dimension to % (50%, 100%, 150%) using num( xx,'##.#0%') in Table 1. Also, I was unable to multiply Sales by Sales % in Table 2.

Thank You

Tracy

[anbu1984 · Accepted solution]

Check this qvq