5 Replies Latest reply: Oct 12, 2011 5:38 AM by Cem Yigman RSS

    Using dimension value in expression formula

      Hello everyone,

       

      I need to use my dimension value in the expression formula.

       

      The table has always last 12 months as dimension and sum of debts as expression. I want to calculate sum of debts for the every dimension value (month).

      I need to write a formula like;

       

      =Sum(if(DATE_ON_PAPER<='monthname',VALUE))

       

      for every month, in order to get the monthly picture of the total debts and how the trend is going...

       

      Could you please help me?

       

      Thank you...

       

      dim_exp.jpg