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))

[karthikeyan1504]

In number format, please check 'Show in percentage' option

[Chanty4u]

hi,

[Anonymous]

what respect you want?

you can do it, like

(CurrentMonth-PreviousMonth)

/

CurrentMonth

or

(CurrentMonth-PreviousMonth)

/

PreviousMonth

depends on your requirement

[priyarane]

actula requirement for RWA% is

sum(rwa)/Sum(ead) then we will change it to % in number tab

but here we have current and previous both, so I have confused

[karthikeyan1504]

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

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

/

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

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

Try above and have the number format in percentage

[Anonymous]

Then I doubt for same that with mentioned expression you will get RWA%?

[tyagishaila]

Hi Priya,

If you want to show relative percentage (Row wise sum/ total sum)

check Option Relative (Chart properties -> Expression -> Click on checkbox Relative)

[Anonymous]

what is the mean of vPrevMonth w.r.t vPrevYear...??

I think It should be like..

vCurrMonth w.r.t vPrevYear...

or

vPrevMonth w.r.t vCurrYear...

[priyarane]

I wanted show this, RWA/EAD = RWA%

above all not worked out