4 Replies Latest reply: Feb 28, 2012 8:00 AM by Alexander Gonchar RSS

    Calculatins sales of specific hours (night sales)

      There are 3 shops, saling goods.

      as we have diffent taxes for nigh sales in them we need to calculate sales at night diffently.

      The problem is that in every shop night time start and finish are diffent.

      How cal we calculate night sales if we have start and end night hours for every shops?

      Shopsnight startnight end
      shop122:008:00
      shop223:008:00
      shop320:007:00



       

       

       

      the main ideai is that there about30 shops and diffent night hours for each of them.

      It should be a straight table with  stores in demension and calculating sales, night sales in expressions.

      ShopSales only night sales
      shop110$4$
      shop224$10$
      shop319$8$