AnsweredAssumed Answered

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

Question asked by paintboothguy on Jan 27, 2010
Latest reply on Jan 27, 2010 by fxdb


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?