Percentage expression

[priyarane]

Hi Community,

How to get percentage for this expression in straight table

(sum({<%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}>}RWA)

/sum({<%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}>}EAD))

-

(sum({<%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}RWA)

/sum({<%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD))

[Anonymous]

From your snap shot, it seems you are having label EAD and RWA of both expression, is it?

If yes, simply write:

Label of RWA expression i.e RWA / EAD(Label of EAD expression)

and then select relative from Expression Tab for this expression

Hope this will help!!

[Anonymous]

see the attachment

[tyagishaila]

did you not get any value in RWA% column, or you get wrong values.

if you get values thn to convert these values into %

go to Chart Propertis -> Number -> Click check box Show in Percentage.

[priyarane]

in this case percentages are wrong

rwa/ead * 100

[Anonymous]

no need to multiply by 100..

Just divide RWA label / EAD Label

and select relative option for that expression

[tyagishaila]

use Show in Percentage,

are you using correct formula to get RWA%,

it may be, RWA / (RWA+EAD)