Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: custom formula on cross-tab Post Reply Post New Topic
Author Message
jjara
Newbie
Newbie


Joined: 21 Jul 2008
Location: Peru
Online Status: Offline
Posts: 1
Quote jjara Replybullet Topic: custom formula on cross-tab
    Posted: 21 Jul 2008 at 6:05pm
I have a cross-tab like this

                  JAN    FEB    MAR ....... DEC (the 12 months as columns)
year 2006
item 01 150 205 300 ....... 550
item 02 80 190 284 ........ 620
 
year 2007
item 01 458 235 224 .......... 781
item 02 154 254 134.......... 254
 
year 2008
item 01 245 154 544 1243
item 02 524 254 124 ......... 924
 
I want to know if is possible to have a formula that take the value of each month and compare with the previous and make a calcule like this...
 
JAN FEB MAR ....... DEC (the 12 months as columns)
year 2006
item 01 150 205 300 ....... 550
item 02 80 190 284 ........ 620
 
year 2007
item 01 458 235 224 .......... 781
(205) (14)
item 02 154 254 134.......... 254
 
year 2008
item 01 245 154 544 1243
item 02 524 254 124 ......... 924
 


where (205) and (14) are calculate from:
(205) = (150 - 458) * 100 / 150 I have to make this operation for each month takin the values from item 01 from 2006 with the values from item 01 from 2007 and so on
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.