Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Write a formula in OLAP report		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

drindone

USA
11 Posts
Posted - 02/02/2006 :  11:01:13  Show Profile  Reply with Quote
I want to create a new variable that is field 1 divide by field 2. I want to display this new variable on the OLAP report. Can this be done?

Thanks

admin

1644 Posts
Posted - 02/02/2006 :  23:06:45  Show Profile  Reply with Quote
Here is an example of how you might do this:

1) Open the “Calculated Measures” dialog and add calculated measure "Test1" with your formula
2) Add calculated measure "Test2" with your formula
3) Add calculated measure "Test3" with this formula: [Measures].[Test1] + [Measures].[Test2]

http://www.reportportal.com/help/olap/calculated.htm
Go to Top of Page

drindone

USA
11 Posts
Posted - 02/03/2006 :  06:05:02  Show Profile  Reply with Quote
Great, that worked.

Thanks....

quote:
Originally posted by admin

Here is an example of how you might do this:

1) Open the “Calculated Measures” dialog and add calculated measure "Test1" with your formula
2) Add calculated measure "Test2" with your formula
3) Add calculated measure "Test3" with this formula: [Measures].[Test1] + [Measures].[Test2]

http://www.reportportal.com/help/olap/calculated.htm
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page