Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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!!
see the attachment
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.
in this case percentages are wrong
rwa/ead * 100
no need to multiply by 100..
Just divide RWA label / EAD Label
and select relative option for that expression
use Show in Percentage,
are you using correct formula to get RWA%,
it may be, RWA / (RWA+EAD)