Allocated memory exceeded - dimension limits

[#1]

I have a straight table and I need to get the top largest 25 amounts based on my first expression.  My first expression is this..

=

if(vShowWindow='% CHANGE',((column(7)/Column(8)))-1,if(vYearIndicator='Current' and $(CurrentBilling)>= vTreshHoldSize,$(CurrentBilling),if(vYearIndicator='Prior' and $(PriorBilling)>= vTreshHoldSize,$(PriorBilling))))

I tried using the 'Dimension Limit' tab by selecting Largest and entered 25 however, I am getting 'allocated memory exceeded' message.  I can get this to work if I go to the 'Presentation' tab and enter in 25 in the Max Number and sort descending on the first expression.  The problem with this is that I have a threshold text box that users enter in and it does not seem to sort or I am getting some funky results.  I would really like to use the dimension limits but it is not working.  Any thoughts? Is this a bug?

This problem is happening in QV 11 SR1 and SR2. 

[MayilVahanan]

HI

Try rank function..

Like

=if(rank(sum(sales)<= 25, sum(Sales))

it display highest 25 values.

Hope it helps

[#3]

After some trial and error, I found that the below calculation (in red) in the below expression was causing the allocated memory exceeded issue.

=if(vShowWindow='% CHANGE',((column(7)/Column(8)))-1,if(vYearIndicator='Current' ,$(CurrentBilling),if(vYearIndicator='Prior',$(PriorBilling))))

If I remove the above calculation (in red) and replace it with the actual formula titles, i no longer get the error.

=if(vShowWindow='% CHANGE',(($(CurrentNormalShare))/($(PriorNormalShare)))-1, if(vYearIndicator='Current',$(CurrentBilling),if(vYearIndicator='Prior',$(PriorBilling))))

So far it is working...

[MayilVahanan]

Hi

Got your requirement means happy

Check once with it,

(column(7)/Column(8))-1,

edit:

also test it:

(column(7)/column(8)) gives value? if so, then no probs in your expression..

Regards,

R.Mayil Vahanan.

[#5]

Thank you for your input Mayil,

I did test (column(7)/column(8)).  It still gives me an "allocated memor exceeded" message.  It seems you must implicitly use the formula titles in order for the below  expression to work with dimension limits. 

=if(vShowWindow='% CHANGE',(($(CurrentNormalShare))/($(PriorNormalShare)))-1, if(vYearIndicator='Current',$(CurrentBilling),if(vYearIndicator='Prior',$(PriorBilling))))