Try trim(segmentlabel1)="Now 2 CPD" may be due to trailing spaces it may causing the issue
Try and let me know or lets is it possible to attach workbook with fake data so that it will be easy to help
Kindly mark this answer as correct/helpful to close the thread
i tried but still get False. i created a Trim([SegmentLabel1]), which should return the labels name but trimmed, correct?
it returns an #Error but i cant dig deeper to what it is... any toughts? does this 'remote type' have any issues? BTW, the data is coming from an Extract on tabl Server