1 Reply Latest reply on Mar 1, 2016 9:06 AM by patrick.byrne.0

    Product price relationships

    john pawielski

      I am trying to establish a relationship between two products.  I have a model built to determine new sell prices, but want to build another calculation to ensure two products always maintain a certain relationship.  For example product A shows a sell price of $10 and prodcut B shows a sell price of $8.  If i want the relationship to always be product A is $1 more expensive than product B (B is the driver), how would i accomplish this?  There are 50 products but only a few need relationships.

       

      Sell price is an aggregated calcuation based on other data points and calculations in the data set.

       

      Any help would be appreciated.

       

      JP