Quarters sum up

[kkkumar82]

All,

I have a requirement to be accomplished.

Lets say I am in Q1 2016 (as we are in March), based on the quarter

if we are in Q1 I want to add up Q2 + Q3 + Q4 Amount

if we are in Q2 I want to add up Q3 + Q4 Amount

if we are in Q3 I want to add up Q4  Amount

if we are in Q4 I want to show 0

In the attached qvw in second sheet I tried a logic for achieving this using some if stuff, I have also done the same on months ,

I just wanna know any better logic than this.

If so please add to this.

Thanks

Kiran Kumar

[sunny_talwar]

May be this as an alternative:

=Sum({<Year = {$(=Year(today()))}, QuarterNum  = {"$(='>' & Ceil(Month(Today())/3))"}, Date, Quarter, Month>} Amount)

Where QuarterNum is created in Script like this:

ceil(Month(Date($(vDate) + Rowno() -1 ) )/3) as QuarterNum,

[#3]

Try this one,

=Sum({<Year = {$(=Year(today()))},MonthNum = {">=$(=Num(Month(QuarterStart(Today()))) + 3)  <=$(=num(month(Yearend(today()))))"}>}Amount)

[kkkumar82]

Thanks Sunny and Sindhu for your responses.

I think sindhu your expression will increase one more calculation after Quarterstart i.e., +3 .

Sunny your expression is fine and I think it improves performance as I can avoid certain if conditions.

one question here if we are in Nov 2016 will your expression return 0.

Regards

Kiran Kumar

[sunny_talwar · Accepted solution]

Yes it will return 0 when you are in Nov 2016 since its Q4