Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Hi, Thanks for suggestion. Its working fine.