6 Replies Latest reply: Jul 31, 2012 4:12 AM by Richard Pressanti RSS

    basic question

      Hi all,

       

      I have a basic question -- I'm trying to multiple a sum with a single value.

       

      For instance:

      -I have a table with multiple unit sales entrances per SKU

      -Another table has a single value for the price of each SKU

       

      Table A:

      SKU A     4

      SKU A     6

      SKU A     10

       

      Table B:

      SKU A     $2.00

       

      I'm trying to do (sum(table A))*(value(table B)), as the answer would be $40.00 for SKU A in this case.

       

      How would I value up each SKU?

       

      Cheers,

       

      F.