1 Reply Latest reply: Jul 26, 2013 8:37 AM by Stefan Wühl RSS

    How can I use the '*' character as a character and not a wild card?

      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 = '*'