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
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.
