percentage change possible in cross tab report?

[vj135]

hi,

in the left hand side(rows) of a cross tab report i have listed all the reasons for employees leaving the company.

in the column i have In-voluntary termination, Underneath it i have 2 small columns one called 2005 and the other 2006.

now in the total of the cross tab on each row i want the "percentage change " -- how do i do that?

thanks

 

[lbass]

Your version?

-LB

 

[vj135]

version XI

 

[lbass]

Please see thread149-1356319 for a method to do this.

-LB

 

[vj135]

when i try to save the formula before it says the keyword "then " is missing



if year {'Terms_Sep_2005_Aug_2007_'.Report Year} = 2006 then 1

 

[ssakkerm]

Put parents in Formula:
if year ('Terms_Sep_2005_Aug_2007_'.Report Year) = 2006 then 1

 

[vj135]

when i do that it says


the )is missing

 

[lbass]

Where are you creating this formula? Just use a regular formula, not a SQL expression. It should look like:

if year ({Terms_Sep_2005_Aug_2007_.Report Year}) = 2006 then 1

...I'm guessing, anyway. Just add the field from the field list within year().

-LB

 

[vj135]

if year ({'Terms_Sep_2005_Aug_2007_'.Report Year}) = Sep 2005-Aug 2006 then 1

I am still getting an error. the error says a number, boolean etc is expected here.

I am using the formula workshop

thnaks

 

[lbass]

Is this your own report? How did you create the year columns of the crosstab if your years run September to August? Do your database fields actually have quotes around the table name like that?

-LB

 

[vj135]

1)This is my report

2)Where i work the fiscal year starts from Sep of a year to august of the next year. So i created a column in the excel sheet with the heading "Report year" and labelled each row Sep 2005 - Aug 2006. Also i labelled Sep 2006 - Aug 2007.

3) no the database fields don't have quotes around it -- but when i choose the fields from the formula workshop the fields around it come automatically.

please let me know if you want more description

thanks

 

[lbass]

Are you saying you have not yet created a crosstab within Crystal?

-LB

 

[vj135]

I have created the report as cross tab -- and everything looks great except for the % change.

all i want is % change instead of / or in addition to the total

thanks very very much

 

[lbass]

Try creating formulas like this:

if {'Terms_Sep_2005_Aug_2007_'.Report Year} = "Sep 2005-Aug 2006" then 1

Then follow the instructions in the previous thread.

-LB

 

[vj135]

when i do the last part

whileprintingrecords;
currencyvar yr2006;
currencyvar yr2006;
totext((yr2007-yr2006)%yr2006,2)+"%"//for 2 decimals

it gives me an error saying

the ) is missing and when i click NO it higlights yr2007


any thoughts

thansk

 

[lbass]

There is a mistake in the post. It should be:

whileprintingrecords;
currencyvar yr2006;
currencyvar yr2007;
totext((yr2007-yr2006)%yr2006,2)+"%"//for 2 decimals

There always must be a variable declaration if the variable is referenced in the formula.

-LB

 

[vj135]

i still get an error saying:

the forumula result must be a boolean

please advise

need this report badly to be able to show tomorrow

thanks

 

[vj135]

I tried again -- but still the same error message.

error says "the forumula result must be a boolean"


I am praying you will see this today and give advise on this error.

thanks very much
vj

 

[vj135]

LB -- please please answer

 

[lbass]

I think you must have placed this formula in the wrong place. The formula:

whileprintingrecords;
currencyvar yr2006;
currencyvar yr2007;
totext((yr2007-yr2006)%yr2006,2)+"%"//for 2 decimals

...belongs in format field->common tab->DISPLAY STRING->x+2 area.

Please do not try to apply pressure to people who are volunteering their time. As it happens, the site has been down.

-LB