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?