Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In this first example, all records with field ABC = 'C' are selected and processed.
'C : ' & num(sum ({$< OrderFlag = {1}, trnstatus_uid = {1}, [Text(abc)] = {C} > } if (InYearToDate(calendar_date, VYTD, 0), custtrnitem_net_total_price ))/
sum ({$< OrderFlag = {1}, trnstatus_uid = {1} > } if (InYearToDate(calendar_date, VYTD, 0), custtrnitem_net_total_price )),'#0%')
Here I want to process records with ABC ='*'; However the character '*' is interpreted as a wild card returning all records.
'* : ' & num(sum ({$< OrderFlag = {1}, trnstatus_uid = {1}, [Text(abc)] = {'*'} > } if (InYearToDate(calendar_date, VYTD, 0), custtrnitem_net_total_price ))/
sum ({$< OrderFlag = {1}, trnstatus_uid = {1} > } if (InYearToDate(calendar_date, VYTD, 0), custtrnitem_net_total_price )),'#0%')
What should I do to select only the record with ABC = '*'
Try
[Text(abc)] = {"=[Text(abc)]='*' "}