10 Replies Latest reply: Feb 5, 2014 1:50 PM by Abhi Hariharan RSS

    Error in Calculated Dimension

      Hi all,

       

      I need to use the following expression as a Calculated Dimension:

       

      =FirstSortedValue( aggr(sum(stkh_movement_quantity),stkh_product,stkh_movement_date), -aggr(stkh_movement_date,stkh_product,stkh_movement_date)))

       

      The aim is to give only the most recent movement quantity, based on the latest movement date. It works fine as an expression, however when used as a Dimension I get the //Error in Calculated Dimension. Any ideas where I'm going wrong?

       

      Many thanks for any help.