6 Replies Latest reply: Dec 3, 2015 9:05 AM by Ruslans KLimovs RSS

    Local variables

    Ruslans KLimovs

      I have quiet a big report and many tables within it.

       

      In each table I use similar formulas .. like this:

       

      IF (

      SUM(if((Sale_Category = 1.1 OR Sale_Category = 1.2), Sale_Money, 0))

      /

      SUM(if((Budget_Category = 1.1 OR Budget_Category = 1.2), Budget_Money, 0))

      < Water_C2,

       

       

      Is it possible to define formula  s ONE local variable ... like CHECK =.... ???

      SUM(if((Sale_Category = 1.1 OR Sale_Category = 1.2), Sale_Money, 0))

      /

      SUM(if((Budget_Category = 1.1 OR Budget_Category = 1.2), Budget_Money, 0))

       

      a

       

      I can't do it in Settings-Variables (global), because it will not take local filters into account during the calculation.