Forum Discussion

TylerPeplinski's avatar
TylerPeplinski
Frequent Visitor
5 years ago
Solved

Tiered Pricing Formula

Hello,   I'm trying to figure out a formula that will tell me if the tiered pricing makes sense. For example a part number with the lowest qty should have the highest price and the highest qty shou...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    TylerPeplinski See if this is what you are looking for:

     

    Column = 
    VAR __Item = [Item]
    VAR __ProposedPrice = [Proposed Price]
    VAR __Qty = [Min Qty]
    VAR __MinQty = MINX(FILTER('Table12',[Item]=__Item && [Min Qty]<__Qty),[Min Qty])
    VAR __ProposedMinQtyPrice = MAXX(FILTER('Table12',[Item]=__Item && [Min Qty]=__MinQty),[Proposed Price])
RETURN
    IF(ISBLANK(__MinQty),FALSE(),IF(__ProposedPrice > __ProposedMinQtyPrice ,TRUE(),FALSE()))

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

TylerPeplinski See if this is what you are looking for:

 

Column = 
    VAR __Item = [Item]
    VAR __ProposedPrice = [Proposed Price]
    VAR __Qty = [Min Qty]
    VAR __MinQty = MINX(FILTER('Table12',[Item]=__Item && [Min Qty]<__Qty),[Min Qty])
    VAR __ProposedMinQtyPrice = MAXX(FILTER('Table12',[Item]=__Item && [Min Qty]=__MinQty),[Proposed Price])
RETURN
    IF(ISBLANK(__MinQty),FALSE(),IF(__ProposedPrice > __ProposedMinQtyPrice ,TRUE(),FALSE()))

 

TylerPeplinski's avatar
TylerPeplinski
Frequent Visitor
4 years ago

Greg_Deckler Greg - Do you think you could help me with this issue we are having? For the example in the screenshot, we want it to say TRUE. I think the problem is that the MOQ is the same. Please let me know your thoughts.