7 Replies Latest reply on Jan 27, 2010 11:02 AM by Steve Wright

    Can Someone Suggest a Calculation Formula?.....



      Can Someone Suggest a Calculation Formula?.....


      Hello All, 


      We would like to have a product serial # generated and displayed on our invoices.  The # needs to be the Model # (AF 130810) followed by the invoice date.  Example = AF 130810 1/24/2010.  Here is what I have so far.


      -An 'Invoice Generator' field with a radio button set where users check the appropriate model #.

      -A calculation field that displays the compiled serial number.


      Here is the equation that compiles the serial number:


      Case(Booth Serial # Generator = "AF 130810" ; "AF 130810" and Lookup (All Invoices::Date))


      This calculation just reports the # "1".


      Can anyone suggest an equation that will accomplish this task?