ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Write a formula in OLAP report

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
drindone Posted - 02/02/2006 : 11:01:13
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
2   L A T E S T    R E P L I E S    (Newest First)
drindone Posted - 02/03/2006 : 06:05:02
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

admin Posted - 02/02/2006 : 23:06:45
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

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page