What will be the Expression for the Line Chart for the following condition
I have slected a saleno from input box say 26 then in line chart it will show the values of average price starting from saleno 14 to 26 and saleno 1 to 13 and it is showing by this expression
if(SaleNo>=14 and SaleNo<=$(=vToSaleNo),Avg({$<SaleNo={"<=$(=$(vToSaleNo))"}>}If(PRICE>0,NETAMT/SOLDWT)),if(SaleNo<14 ,Avg({$<SaleNo={"<=$(=$(vToSaleNo))"}>}If(PRICE>0,NETAMT/SOLDWT))))
but when i select saleno=8 it should show saleno 1 to 8 and 14 to 52
