Concat Function

[nevilledhamsiri]

Hi Sunny,

Appreciate if you could refer this & help me out. This was developed with your former information that I had received!

I have applied the said function to bring back the reasons to the Pivot table from the mapping table which reason should always possible only if the the type of visit equal to ''Late day visit'' (Date to visit<> date visited). Please see what mistake I have done as I do not get it appear in cases where above criteria is met.

SUM({<[Person Visited]={'Neville','Vernon','Mahesh','Iresha','Sineka'},[Branch visited]={'Thanamalwilla','Angunakolapelessa','Godakawela','Eheliyagoda','Kuruwita','Balangoda','Palebedda','Middeniya','Embilipitiya','Kalawana','Kiriella','Pelmadulla','Kahawatta'},Fixed_Month={'Jan'},Type_Of_Visit={'Late_Date_Visit'}>} Aggr( Concat([Reason For late]),[Branch visited],[Person assigned for Visit],[Person Visited],Fixed_Month))

Many Thanks

Neville

[nevilledhamsiri]

Please refer the Ammended  attachment & as per the requested expression.

I hope to update the mapping table monthly with remarks only for late visit so the reason for late visit to be picked every month if there is a ate visit.

SUM({<[Person Visited]={'Neville','Vernon','Mahesh','Iresha','Sineka'},[Branch visited]={'Thanamalwilla','Angunakolapelessa','Godakawela','Eheliyagoda','Kuruwita','Balangoda','Palebedda','Middeniya','Embilipitiya','Kalawana','Kiriella','Pelmadulla','Kahawatta'},Fixed_Month={'Jan'},TYPE_OF_VISIT={'LATE_DATE_VISIT'}>} Aggr( Concat([Reason For late],','),[Branch visited],[Person assigned for Visit],[Person Visited],Fixed_Month))

[nevilledhamsiri]

Would you mind looking in to this please

Regrds

Neville