### Title

Varied Pricing

### Post

I am developing an invoicing solution. Many products are priced as a set pricing (i.e. labor for installation is $10).

Others are priced by the square foot. Others are priced by the square yard. Others are priced using a custom price matrix(where the price is a function of width and height, but with no direct calculation involved).

My question is how do I set up the relationship within the portal so that I am able to select any of the products and get a price?

If the product does not require a width or length, then there will be no need to enter one. Likewise if the product needs a specified dimension, then those fields will be required.

Much thanks

Ric

For many of those situations, you can check out the evaluate function. You can store the calculation expression for a given item in a pricing table and then you look up the calculation and use evaluate to apply it to the current record.

For your matrix solution, I'd try real hard to generate a calculated expression that produces the same results as the matrix as that will be easier to implement. If that isn't possible, you can use a separate look up to look up the values from your matrix and an auto-enter calculation can select from either source (Price list or pricing matrix) based on values you've entered in the invoice line item record for that item.