concat two firstsortedvalue expression.

[Anonymous]

Hi,

I want to combine two expression come as a single filed.

concat( FirstSortedValue([DWH_IM_MONTH],-AGGR(SUM(SALES_IM_QTY),DWH_SKU_REF_NO,DWH_IM_MONTH,DWH_IM_DATE_YEAR)) , FirstSortedValue([DWH_IM_DATE_YEAR] , -AGGR(SUM(SALES_IM_QTY),DWH_SKU_REF_NO,DWH_IM_MONTH,DWH_IM_DATE_YEAR)),'&')

can someone tell me whats wrong with this Formula.

[jerem1234]

For something like that, you don't want to use the concat function. The concat function will cycle through a field and concat all the values together. What you want to do is combine the two expressions into one value. Try:

=FirstSortedValue([DWH_IM_MONTH],-AGGR(SUM(SALES_IM_QTY),DWH_SKU_REF_NO,DWH_IM_MONTH,DWH_IM_DATE_YEAR)) & '&'  & FirstSortedValue([DWH_IM_DATE_YEAR] , -AGGR(SUM(SALES_IM_QTY),DWH_SKU_REF_NO,DWH_IM_MONTH,DWH_IM_DATE_YEAR))

Hope this helps!

[Anonymous]

Thank you so much Jermiah, worked absolutely fine, Really appreciate your quick response.