0 Replies Latest reply: Aug 10, 2012 9:59 AM by Marcos Herrera RSS

    Result of expression between range

      I have a problem with the result of an expression which does not understand, to put it in context of the situation, I have an asociative model for which there is a large fact table and some dimensions. There is also a draw isolated model in which there is a range qualification.

       

       

      My problem is in a pivot table for which the result of an expression must be qualified according to the table of ranks. The rating makes this expression works well only for some ranges.

       

      This is the expression to evaluate

       

      Sum({<Base={1}>} [Valor ventas])

      /

      Sum({<Base={1}>} [Valor presupuesto ciclico])

       

      And this is the expression to Qualify in ranges

       

      aggr(if( $(vCumplimientoPpto.)<=[Escalas compensacion mayoristas.Rango Max]

           and $(vCumplimientoPpto.)>=[Escalas compensacion mayoristas.Rango Min] ,

                                      [Escalas compensacion mayoristas.Valor escala]

              ),

           [Escalas compensacion mayoristas.Valor escala],[Negocio compensacion])

       

       

      Where $(vCumplimientoPpto.) solve the formula that is contained in variable vCumplimientoPpto.

      "

      Sum({<Base={1}>} [Valor ventas])

      /

      Sum({<Base={1}>} [Valor presupuesto ciclico])

      "

      in the variable the formula are without "=" at begin

       

      Check the Pivot table result and Range Qualification Table

       

      Pivot Table

      Pivot.png

      Table of Qualification Ranges

      TableRanges.png