QOQ variance Calculation for First Quarter

[joshibabu_are]

Hi All,

I want to show      QoQ Varaiance.

Expression For 2017 Q1 Variance:

(Q4 Amount -Q1 Amount )/Q1*100

Same Logic For All Quarters .

I want dynamic Expression to achieve this .

please find the attached screen shot and data file and Qvf file

Result for 2017 Q1 should be: -20%

Any Help would be greatly appreciated.

stalwar1‌

Thanks,

Joshi

[sunny_talwar]

When you say max year, do you mean the same data that we see when 2017 is selected or data when nothing is selected?

[sunny_talwar]

Try this:

Aggr(Above(Sum({<Year, Quarter, YearQuarter>}Amount))/Sum({<Year = {"$(=Max(Year))"}>}Amount)-1, Division, (YearQuarter, (Text)))

[joshibabu_are]

Hi Sunny,

Thanks for your Help.its working Perfect.

but small change in requirement.

how to change your expression for below case

2017 Q1 Amount-2016 Q4 Amount/2016 Q4 Amount.

Thanks,

joshi

[sunny_talwar · Accepted solution]

This should do it

Aggr(Sum({<Year = {"$(=Max(Year))"}>}Amount)/Above(Sum({<Year, Quarter, YearQuarter>}Amount))-1, Division, (YearQuarter, (Text)))