concat aggr?

[n1ef5ng1]

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

[Gysbert_Wassenaar]

Try $(=Concat( _Dimension_Pick,',')) so that the concat is calculated outside the context of the rest of the expression. Coincidentally I just posted something similar here: Conditional show Straight table based on number of rows. Perhaps you can use that example to see how/that it works.