I am trying to set formula to derive final price of item from multiple price list setup. We have got 6 different pricelists. The item will have its price only in 1 pricelist. The item is not repeated in any other pricelist. Currently my client expression for series item_price has several if conditions checking each pricelist one by one. Can I use any other function to simplify this?
Appreciate any help on this.