AnsweredAssumed Answered

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

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

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 

Outcomes