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

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

    paintboothguy

      Title

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

      Post

      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?

       

      Thanks,

      Andrew