Format within an expression

[#1]

I am working on an expression where I am attempting to show the percent.  However the requirement has changed to show the numerator, denominator and the percent all within the same column.  I can get this to work but cannot figure out how to then format the percent calculation piece to only show 2 decimal places.  Any ideas?  I could probably split this into 2 columns but would need the expression title to be spread over both columns and I am not sure how to accomplish that.  This is all being done in a pivot table.  Thanks in advance!

[shree909 · Accepted solution]

Hi,

num(ur expression,'#,##.#0%')   this will give 12.23%  depending on ur expression

[#3]

Thanks, this worked our perfectly.  I only modified the last 0 to a # in the formatting to get the correct rounding.