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.
An alternate option:
While loading these price lists into Demantra, you may want to load another series which represents unit price for all the items. This can be done as part of load process with a simple customization.
This will simplify your series expressions and would also help with performance of worksheets which use price list as series.