% Increase On Text object.

[MuraliPrasath]

Hi QV Team,

I have following text objects respectively.

For "IO YTD" 2017 this is the expression:      num(sum({<FactType={IO},Jahr={$(vAY)},Monat={$(vActualMonth)},Tag={"<=$(vDayToday)"}>}NET_VALUE_IN_EUR),'#.##0')    Answer:  66.513878

For "IO YTD" 2016 this is the expression:     num(sum({<FactType={IO},Jahr={$(vAY)},Monat={$(vActualMonth)},Tag={"<=$(vDayToday)"}>}NET_VALUE_IN_EUR),'#.##0')    Answer:  718.087.840  

Now I need an expression to calculate the Percentage increase or decrease of 2017 vs 2016.

Need Help!

[sushil353]

Hi,

For IO YTD.

Try this:

num((sum({<FactType={IO},Jahr={$(vAY)},Monat={$(vActualMonth)},Tag={"<=$(vDayToday)"}>}NET_VALUE_IN_EUR)

/sum({<FactType={IO},Jahr={$(vAY)},Monat={$(vActualMonth)},Tag={"<=$(vDayToday)"}>}NET_VALUE_IN_EUR))-1.'#,##0%')

HTH

Sushil

[muthukumar77]

(Year2017-Year2016)/Year2017

if output come as negative, Decrease.

if output come as Positive, Increase.