Prior Quarter Count Help

[Anonymous]

Hi All,

I need help with an expression that can COUNT prior quarter items. Currently, i select a quarter date listbox where it will return a count status total for this quarter. At the same time, i want to have a count total for prior quarter.

For example:

Selected 12/31/2014

Returns a count of 100

Also, wants a return count of prior quarter (9/30/2014)

count([Status])

Any inputs will greatly appreciated!

Thanks,

Frank

[sunny_talwar · Accepted solution]

Try this in a text box may be:

=Count({<Date = {"$(='>=' & Date(QuarterStart(AddMonths(Max(Date), -3))) & '<=' & Date(QuarterEnd(AddMonths(Max(Date), -3))) )"}>} Status)

[Anonymous]

Again.. Thank You Sunny!

Before I used this expression but not working..

=count({<Valuation_Quarter={"$(=date(quarterend(max(Valuation_Quarter),-1),'MM/DD/YYYY'))"}>} [Status])