Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
Thank you so much Jermiah, worked absolutely fine, Really appreciate your quick response.