Set Analysis Syntax

[#1]

In my fiscal calendar table, I have a column called QtrIndex that sequentially numbers each fiscal quarter. In my expression, I would like to evaluate both current quarter and prior quarter's sales to get the overall change. However, I'm having trouble writing the expression to sum the previous quarter's sales. Can someone help with the correct expression. This didn't work and I'm not sure why:

sum({$<QtrIndex = {$(QtrIndex-1)} >} POSAmt)

[spsrk_84]

Hi,

Try like this

sum({$<QtrIndex = {$(QtrIndex)-1} >} POSAmt).

Regards,

Ajay

[#3]

That gave me a syntax error. I tried the following, and it didn't work either:

Sum({$<QtrIndex={$(=QtrIndex-1)}>}POSAmt)

[#4]

Hi,

Try using below formulae.

=sum({<QtrIndex= {$(=Max(QtrIndex)-1)}>} POSAmt)

- Sridhar

[#5]

Sorry, but this formula will only work for the most current Quarter. I'm performing the calculation for all quarters to get the change in growth, as follows: (ThisQuarterSales / PriorQuarterSales) - 1. So, I cannot use a max function here.

[d_pranskus]

I think it will work for the Quarter which is selected, in Case there are no selections in calendar table it will return most current quarter.