dbTalk Databases Forums  

calculate variance

comp.databases.olap comp.databases.olap


Discuss calculate variance in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jojykk
 
Posts: n/a

Default calculate variance - 07-10-2008 , 12:32 PM








i have Query1 and Query2
Same columns in both (say c1, c2, c3, c4)

I want a Query3 with
Query3.c1 = Query1.c1 - Query2.c1
Query3.c2 = Query1.c2 - Query2.c2

where
Query1.c3 = Query2.c3 and
Query1.c4 = Query2.c4

this is the simplest way i can explain it
Please help me out on this by sending the answer to jojy.kk (AT) gmail (DOT) com

Thnks
JOjy

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.