Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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))
Thanks for the reply but the expression is not working
Hi
Try Some thing Like this
if(Month=max(Month),if( isNull(NewStock),Month=max(Month-1) and max(NewStock),max(NewStock))