Post reply

Conditional Help

  • May 25, 2007 at 7:28 am

    #119096

    The powers that be need a column that says if the price is on sale or not.  The problem is that the prices are derived from a price matrix.  Meaning that the prices is dependent on the quantity purchased. 

    How can I add a column that I can have it say "special price" or "not" from a list that one item could have many different lines? 

    Please Help.

    Thanks

    Chad

     

  • May 25, 2007 at 7:50 am

    #708960

    Chad

    I'm afraid I don't understand what you mean.  Please will you provide DDL for your table(s) and some sample data, and somebody should be able to help you.

    Thanks

    John

  • May 25, 2007 at 8:00 am

    #708964

    John,

    I was afraid that people would not understand what I was talking about.  Here is some sample data.

            

    Sale:

    Item: GPH113

    Price: 12.00

     

    Price Matrix:

    GPH113

    Qty:>9        Price: 12.00

    Qty:<9 and >24    Price: 11.00

    Qty: <24 and >50  Price: 10.00

    etc, etc, etc.

    The Item, Qty, and Price are all in seperate columns in the table. 

    And this is for hundreds of items.  In this case the Sale Price was in the matrix so it would not be a "special price", so I would want the column to say "Not". 

    I hope that this helps clarify.

     

    Thanks

  • May 28, 2007 at 11:22 pm

    #709266

    I Understand your requirement,Can you please send me the sample matrix you are showing now.

    As i understood,you dont want to disturb the present matrix,but you want to add another columns which says the special price.

    As i am confused when you said "Matrix". please send the model of the matrix you want to see now.It can help us to give the appropriate solution

     

    Thank you,

    Raj Deep.A

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply