Search the Community
Showing results for tags 'pettern'.
Found 1 result
Hi Forum, Please help me solve a calculation for this problem, i have a table with various records, i would like to implement a field called Order_Check that would display a "1" if the table field Order_Num begins with "PT00" if otherwise it must display "0". This field Order_Num for invoice records appear to be either empty, has value ID that begins with PT00* or just have some random values, i tried the calculation: IF(Order_Number = "PT00*", 1, 0) Thank you for assisting, Miss-Amen!