0 Replies Latest reply on Nov 13, 2012 8:45 AM by s0uLr1pPeR

    How to take a 3d previous member of a current member in a YearTotal dim?

    s0uLr1pPeR
      Hello, im working with exchange rates table atm and there is a task to recalculate a cell in an April month using exchange rate from January and futher using the same algorithm.

      I tried shift, but it returns a cell value, and i need some analogue like @shift(@currmbr("YearTotal", -3)) but with a member return type.

      Goal is to take 3d previous member from current member of YearTotal (months) dimension

      Any suggestions, please?