Exclude Year selection in expression

[vireshkolagimat]

Hi All,

I've the below expression which calculate the sum InvQty based on the set analysis expression.

=sum({<StockTransType={'STKTKEFULL'}, TransNo={'$(=MaxString(TransNo))'}, Year= >}InvQty)

I don't want the exp value to change if they make selections in Year list box so i have excluded it in the exp.

But if select the Year list box, the value is changing. I need to keep this value as constant.

what is wrong in my expression? Thanks 

VK

[Vegar · Accepted solution]

I guess you would need to add the set into your maxString() function as well.

=sum({<
     StockTransType={'STKTKEFULL'}, 
     TransNo={'$(=MaxString({<StockTransType={'STKTKEFULL'},Year=>}TransNo))'}, 
     Year= >}InvQty)

[vireshkolagimat]

Hi, Thanks for suggestion. Its working fine.