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
Table of Qualification Ranges