Leverage Excel Formulas within Report

Post Reply
User avatar
US_Helpdesk
Moderator
Moderator
Posts: 1092
Joined: Wed Feb 23, 2011 7:26 pm

Leverage Excel Formulas within Report

Post by US_Helpdesk » Thu Dec 22, 2016 11:56 am

It is possible to include Excel Formula into CMM Report. Simply open original copy of report in Excel, add the formula in a Note field of the report, then copy the text from Excel back into the Note field of the original CMM-Manager report operation.

The Excel Formula can be entered in as Note in Report or as User Note as shown below:
excel_formula.jpg
The results in native CMM-Manager report just show raw Excel Formula:
excel_formula1.jpg
However, once opened in Excel the magic happens and you see the result of the "calculated" formula:
excel_formula2.jpg
You do not have the required permissions to view the files attached to this post.
I've migrated to a new user account, see my other posts here

User avatar
Ryan Christopher
Nikon
Nikon
Posts: 230
Joined: Mon Jun 06, 2011 3:00 pm
Location: Sumner Washington
Contact:

Re: Leverage Excel Formulas within Report

Post by Ryan Christopher » Thu Dec 29, 2016 12:18 pm

nice
Ryan Tackes
Applications Manager, VMS Inc.
http://www.vantagemeasure.com/

Post Reply