3 Replies Latest reply: Jul 21, 2014 5:08 PM by Matt Davis RSS

    Variable question

      Hi - I'm looking for a simpler way to do the following.  I want to look at data from all transactions with a certain SKU # in the transaction.  My current formula is:

       

      SUM({$<TRANSACTION_KEY = P({1<SKU = {'5476024'}>} [TRANSACTION_KEY])>} NET_SALES)

      I would like to use an input box to input the SKU number rather than type it in the formula, but this type of formula doesn't seem to allow it.  What is the best way to handle this?  I may be over-complicating this as well, so any suggestions for simplicity works too.  Thank you - Matt