9 Replies Latest reply: Apr 4, 2012 8:44 AM by Marcos Herrera RSS

    Format number problem in Rolling N months

      Hi Dear QV Community

       

      I have this expresion to made a N rollling months in a Pivot Table with two dimmentions ([Indicadores productividad fideicomisos] and Periodo)

       

      = If(Match(Mid([Indicadores productividad fideicomisos],1,5),'Total')=0,

      Num(Sum({<Periodo= {">=$(=Date(addmonths(Max(Periodo), -vRolling), 'MMM-YY')) <=$(=Date(addmonths(Max(Periodo), 0),  'MMM-YY'))"}>} [Valor Indicadores productividad fideicomisos]),'#.##0%')

      ,Num(Sum({<Periodo= {">=$(=Date(addmonths(Max(Periodo), -vRolling), 'MMM-YY')) <=$(=Date(addmonths(Max(Periodo), 0),  'MMM-YY'))"}>} [Valor Indicadores productividad fideicomisos]),'#.##0')

      )

       

      I want format the result with #.##0% when dimention [Indicadores productividad fideicomisos]  is different to Total* and #.##0 when is equal to Total*

       

      The expression works fine just for the selected period but not for rolling periods

       

      pantallaso.png