6 Replies Latest reply: Dec 6, 2011 8:47 AM by Thom Mumaw RSS

    Calculation (Set Analysis or If)

    Thom Mumaw

      Need a little help.  I am trying to calculate our dollar value based on an exchange rate.  Having a few problems.  It does not like my statement.  Basically if my MTD flag is 1 and company 3000 use exchange rate in calculation otherwise value times -1.

      Thanks

       

      sum({<MTDFlag = {1},[Company Code_RBUKRS] = {3000}>} ([In company code currency_HSL] * [Exchange Rate] * -1),([In company code currency_HSL] * -1))