0 Replies Latest reply: Dec 15, 2009 1:32 PM by desorama RSS

    Revenues at happy hours

    desorama

       

      How can I solve this demand, need to know sales at hoppy hour for articles where have lower price at happy our and articles that no not have a lower price at happy hour. (all articles have two tariff but some have different price and others not.

      Article

      Tariff

      Price

      Quantity

      Revenue

      Revenue 11

      lower

      Revenue 11

      no change

      a

      1

      20

      3

      60

       

       

      a

      1

      20

      4

      80

       

       

      a

      11

      20

      6

      120

       

      120

      b

      1

      36

      1

      36

       

       

      b

      11

      18

      3

      54

      54

       

      c

      11

      25

      5

      125

      125

       

      c

      1

      50

      6

      300

       

       

      c

      11

      25

      1

      25

      25

       

       

       

       

       

       

      204

      120

       

      Articles can be sold at different Prices depending on Tariff applied (Happy hour)

      Some Articles have same price independedly of Tariff applied (Happy hour)

      I am aiming for

      1. Revenues for Articles sold at Tariff 11 (where Price 11 = Price 1)

      2. Revenues for Articles sold at Tariff 11 (where Price 11 not equal Price 1) but only the ones sold at Price 11 lower than Price 1

      Thanks