1 Reply Latest reply: Oct 1, 2014 10:14 AM by Gysbert Wassenaar RSS

    concat aggr?

    ben lim

      Hi

       

      I have a complex formula to derive a certain value based on aggr

       

      If ( VPERF_Inter_Gateway_Barge_Indicator = 'X',

           Sum ( Aggr ( Sum ( VPERF_Total_Moves * VPERF_Vessel_Rate ), text($(Concat ( _Dimension_Pick,','))) ))

           /

           Sum ( Aggr ( Sum ( VPERF_Total_Moves ), text($(Concat ( _Dimension_Pick,','))) ))

         )

       

      _Dimension_Pick is a selection for user to select

       

      _Dimension_Pick:

      LOAD * INLINE [

      _Dimension_Pick

           Box,

           TEU,

           Year,

           Month, 

           Terminal_Id,

           Vessel_Type,

      ];

       

       

      Based on user selection, the aggr selection will show tweak to achieve the correct formula.

       

      however, based on the expression above, it gives an error as it is unable to read text($(Concat ( _Dimension_Pick,','))) whileas textbox does when i insert the code. any reason why