help in expression

[#1]

Hi,

In my sample application in the table box there is  a field 'newstock', for the 'newstock'  I need an expression that should the current month highest data, if the data isn't present for that month it should show the previous month highest data like vice versa

[#2]

In detail If my current selection is equal to Month then it should display the maximum of NewStock. If the newstock is null then it should go to the immediate previous month as this condition should repeat

[sasikanth]

Hi

Try some thing lIke this

if( isNull(max({<month={'&(=max(Month-filed))'}>} NewStock)),max({<month={'&(=max(month-filed-1))'}>}NewStock),max({<month={'&(=max(Month-filed))'}>} NewStock))

[#4]

Thanks for the reply but the expression is not working

[sasikanth]

Hi

Try Some thing Like  this

if(Month=max(Month),if( isNull(NewStock),Month=max(Month-1) and max(NewStock),max(NewStock))