1 Reply Latest reply: Mar 19, 2013 5:11 AM by NB13 RSS

    Help on writing a formula

      Hi Guys,

      I am trying to perform a currency calculation (not using the currency conversion). I am writing a member formula for

      Dimension - Currency
      Local - Store
      Mark - Dynamic
      Dollars - Dynamic [member formula example given below]

      Dimension - Country
      Company 1 (UDA USD)
      Company 2 (UDA DEU)
      Company 3 (UDA DEU)
      Company 4 (UDA USD)

      Everything is entered in Local currency.

      This is what I am trying to do

      Below member formula for 'Dollar'

      If Level 0 member
      If UDA (Mark)
      USD = Local * 1.2;
      If UDA (USD)
      USD = Local ;
      Else if
      Aggregate parent

      This is what I am trying to achieve using the member formula for 'Dollar'. When it tries to calculate for Level 0 members - Company 1,2,3,4 it should perform calculation. If it's parent, then just add up. I hope I am clear. Here's a screenshot of what I am trying to achieve : http://img839.imageshack.us/img839/2764/currency.png